cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

Basam.Nath
Builder

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

1 REPLY 1

Radhika.Puthiyetath
AppDynamics Team (Retired)

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.