now

This section contains reference documentation for the now function.

Return current time as epoch millis.

Signature

now()

Usage Examples

select now() AS now
FROM ignoreMe

This function is typically used in predicate to filter on timestamp for recent data. e.g. filter data on recent 1 day(86400 seconds)

SELECT * 
FROM tableName
WHERE tsInMillis > now() - 86400000