Business iQ (Analytics)

cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted
Builder

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

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

Tags (1)
How to put a date and time condition in a ADQL statement
1 REPLY 1
AppDynamics Team (Retired)

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

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.

 

 

 


Thanks,
Radhika P




Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.