How to put a date and time condition in a ADQL statement

[Basam.Nath]

select * from transactions where order-date is between 01/01/2018 12:00:00 to 01/02/2019 12:00:02

[Anonymous]

Hi @Basam.Nath

Please make a note that the supported timestamp format  is:

• ISO 8601 format: yyyy-MM-dd'T'HH:mm:ss.SSSZZ
• UNIX epoch date format: A 13-digit number representing the number of seconds/milliseconds since UNIX epoch time (Jan 1 1970). For example, (GMT): Mon, 17 Apr 2017 23:46:22 GMT would be 1492472782000.

About Orderdate, it appears to me that Orderdate is collected as a "String" and as you know, date manipulation does not work on string values.