arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

FromEpoch

This section contains reference documentation for the fromEpoch functions.

Convert epoch to epoch milliseconds. The following time units are supported:

  • SECONDS

  • MINUTES

  • HOURS

  • DAYS

hashtag
Signature

FromEpoch<TIME_UNIT>(timeIn<Time_UNIT>)

hashtag
Usage Examples

epochMillis
epochMillis
epochMillis
epochMillis

1613472303000

1613472300000

1613469600000

1613433600000

select FromEpochSeconds(1613472303) AS epochMillis
FROM ignoreMe
select FromEpochMinutes(26891205) AS epochMillis
FROM ignoreMe
select FromEpochHours(448186) AS epochMillis
FROM ignoreMe
select FromEpochDays(18674) AS epochMillis
FROM ignoreMe