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