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