0 Replies Latest reply on Feb 22, 2003 12:40 PM by Nick Antrobus

    Dynamic EJBQL and dates

    Nick Antrobus Newbie

      Hi,

      We need to construct a query that has where clause containing a date element of the form fd.datetime > blah blah.

      We can make it work if we use a string which exactly matches the oracle nls date param but if we try to use jdbc type escape syntax ie {ts ''} with the appropriate format in the ''it doesn't work.

      Anyone any thoughts in how to do this?

      Thanks

      Nick