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