arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

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

hashtag
Signature

ToEpoch<TIME_UNIT>(timeInMillis)

hashtag
Usage Examples

epochSeconds
epochMins
epochHours
epochDays

1613472303

26891205

448186

18674

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