Business iQ (Analytics)

cancel
Showing results for 
Search instead for 
Did you mean: 

Making sense of zulu time format is 'eventTimestamp' shows '2020-09-20T11:28:30.186Z'

Highlighted
Builder

Making sense of zulu time format is 'eventTimestamp' shows '2020-09-20T11:28:30.186Z'

Hello good folks

 

SELECT eventTimestamp FROM transactions WHERE application = "MyPROD" and eventTimestamp BETWEEN '2020-09-20T10:28:30.186Z' and '2020-09-20T10:28:40.186Z'

 

I get the data successfully, but the time is exactly 6 hours behind. What time zone or format is 2020-09-20T10:28:40.186Z

 

The letters 'T' and 'Z' represent the Zulu time format, but I can't understand the results. The results are exactly 6 hours behind the expected.

 

 

 

Tags (1)
Making sense of zulu time format is 'eventTimestamp' shows '2020-09-20T11:28:30.186Z'