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



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?



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.


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


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


@RyanVeitch Sure did and it resolved my issue