Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

Querying on timestamp condition

nrql

#1

Hi team,

When I query on timestamp using “SELECT * FROM PageAction WHERE timestamp SINCE '‘2018-08-22 09:00:00 EDT’ UNTIL ‘2018-08-23 09:00:00 EDT’” does it include records that have an exact timestamp of 2018-08-22 09:00:00 EDT and 2018-08-23 09:00:00 EDT OR does it strictly include records in between the two timestamps by excluding records which exactly match the SINCE and UNTIL timestamps?

-Fenil


#2

Pretty easy to test that by moving your query a second. If you reduce your window to a few seconds you can maybe look at the timestamps.


#3

@fenil.doshi were you able to test this with @6MM’s advice?


#4

Thanks @6MM ! tested it out and got the solution


#5

@RyanVeitch Sure did and it resolved my issue