This section contains reference documentation for the toEpoch functions.
Convert epoch milliseconds to epoch . The following time units are supported:
SECONDS
MINUTES
HOURS
DAYS
ToEpoch<TIME_UNIT>(timeInMillis)
select ToEpochSeconds(1613472303000) AS epochSeconds
FROM ignoreMe
1613472303
select ToEpochMinutes(1613472303000) AS epochMins
FROM ignoreMe
26891205
select ToEpochHours(1613472303000) AS epochHours
FROM ignoreMe
448186
select ToEpochDays(1613472303000) AS epochDays
FROM ignoreMe
18674