How to restrict data based on certain time frame?

I have a NRQL which is giving me desired result. On top that, I want to restrict data based on time frame (i.e. only show me data which is > 24 hrs old). Below query and result shows my current output. Now I just want to show the data which is in online or offline state for more than 24 hours (i.e. only first two data which is highlighted). I don’t know how to add condition based off hours using timestamp.

NRQL:

SELECT latest(status), filter(max(timestamp), WHERE status !='onlineAndReady') AS TimeStamp 
FROM `store:storeStatus` 
HERE tenantName='Smashburger' 
FACET storeNumber SINCE 1 week ago UNTIL NOW LIMIT max

EXPECTED RESULT:

Hey @gparmar

If you only want data 24hrs or older, you could try ending your query at that time:

SINCE 1 WEEK AGO UNTIL 24 HOURS AGO

That is not giving me the desired result. Is there a way to get currentTime in NRQL? i.e. if someEventTime > N hrs then only shows such.

I’m afraid not! There is no currentTime function in NRQL