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 ignoreMe1613472303
select ToEpochMinutes(1613472303000) AS epochMins
FROM ignoreMe26891205
select ToEpochHours(1613472303000) AS epochHours
FROM ignoreMe448186
select ToEpochDays(1613472303000) AS epochDays
FROM ignoreMe18674