| description |
|---|
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 |