Hi all,

I'm trying to figure out the correct syntax for the date AND time format in Freeform SQL.

So far, I've found this syntax works:

[Modified On] > {03/08/2022} order by [Modified On] desc

[Modified On] > {03/08/22} order by [Modified On] desc

However, with time information specified, none of these work. WorldServer displays the error message: Cannot execute query. Error: [SDL WorldServer][Oracle JDBC Driver][Oracle]ORA-00936: missing expression

[Modified On] > {03/08/2022 10:15 AM} order by [Modified On] desc

[Modified On] > {03/08/2022 10:15} order by [Modified On] desc

[Modified On] > {03/08/2022, 10:15} order by [Modified On] desc

[Modified On] > {03/08/2022 10:15:00} order by [Modified On] desc

[Modified On] > {03/08/2022, 10:15:00} order by [Modified On] desc

[Modified On] > {03/08/2022 10:15:00 AM} order by [Modified On] desc

[Modified On] > {03/08/22 10:15 AM} order by [Modified On] desc

[Modified On] > {3/8/22 10:15} order by [Modified On] desc

How can I specify a specific time in my query? 

The online document I found suggests the format {01/20/04 11:15 AM} but it doesn't work.

gateway.sdl.com/.../000011827

Thank you,