◀ Back to Playground Home

Finds rows that have a timestamp value greater than one day ago

SELECT string_field, timestamp_field
FROM users
WHERE timestamp_field > (CAST(now() - 86400000 AS long))