Dates

[EscapeUK]

Using Query Designer and trying to use a date as a parameter.

The DB i am using is an Oracle one and the dates are in the format of 05/05/2001 07:55:48

How do i use this in my SQL statement

desperate help needed.

 

[mathew001]

Try this ( I am not sure though)
table_name."field_name" = {ts '1997-05-15 00:00:01.00'}

 

[EscapeUK]

i need to pass it in as a parameter

 

[mathew001]

When you create the parameter you have to select the option 'DateTime' for 'Value Type'. It should work for you.

Now when you pass the parameter you may aslo try this
DateTime (YYYY, MM, DD, HH, MM, SS) as parameter.