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
ToEpoch<TIME_UNIT>(timeInMillis)
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 |
Last modified 1yr ago