I have set of records which gets updated frequently (every hour per day). What I want is, show me the records which are not updated since last 24 hours? Thus, I can quickly identify records out of many.
SELECT latest(status), latest(timestamp) FROM 'tceRiRic:menuDeltaSync' WHERE tenantName='Smashburger' FACET storeNumber SINCE 3 weeks ago LIMIT MAX
Result: I just want highlighted records.
- I see that I have
dateOf(timestamp)option but how can I compare with current time? i.e. I want to do something like
NOW - dateOf(timestamp) > 24 hrs. If this is not possible the what are the other options?
- If I use
SINCE 3 weeks ago UNTIL 24 hour ago LIMIT MAXthen this gives me 24 hours older records which is also not desired.