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

Last updated