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