Comment on page
TIMECONVERT
This section contains reference documentation for the TIMECONVERT function.
Converts the value from a column that contains an epoch timestamp into another time unit. The converted value will be rounded down.
TIMECONVERT(col, fromUnit, toUnit)
The supported units are as follows:
- DAYS
- HOURS
- MINUTES
- SECONDS
- MILLISECONDS
- MICROSECONDS
- NANOSECONDS
select id,
created_at_timestamp,
cast(created_at_timestamp AS long) AS timeInMs,
TIMECONVERT(created_at_timestamp, 'MILLISECONDS', 'DAYS') AS convertedTime
from githubEvents
LIMIT 1
id | created_at_timestamp | timeInMs | convertedTime |
|---|---|---|---|
7044874109 | 2018-01-01 11:00:00.0 | 1514804400000 | 17532 |
select id,
created_at_timestamp,
cast(created_at_timestamp AS long) AS timeInMs,
TIMECONVERT(created_at_timestamp, 'MILLISECONDS', 'HOURS') AS convertedTime
from githubEvents
LIMIT 1
id | created_at_timestamp | timeInMs | convertedTime |
|---|---|---|---|
7044874109 | 2018-01-01 11:00:00.0 | 1514804400000 | 420779 |
select id,
created_at_timestamp,
cast(created_at_timestamp AS long) AS timeInMs,
TIMECONVERT(created_at_timestamp, 'MILLISECONDS', 'SECONDS') AS convertedTime
from githubEvents
LIMIT 1
id | created_at_timestamp | timeInMs | convertedTime |
|---|---|---|---|
7044874109 | 2018-01-01 11:00:00.0 | 1514804400000 | 1514804400 |
select id,
created_at_timestamp,
cast(created_at_timestamp AS long) AS timeInMs,
TIMECONVERT(created_at_timestamp, 'MILLISECONDS', 'MILLISECONDS') AS convertedTime
from githubEvents
LIMIT 1
id | created_at_timestamp | timeInMs | convertedTime |
|---|---|---|---|
7044874109 | 2018-01-01 11:00:00.0 | 1514804400000 | 1514804400000 |
select id,
created_at_timestamp,
cast(created_at_timestamp AS long) AS timeInMs,
TIMECONVERT(created_at_timestamp, 'MILLISECONDS', 'MICROSECONDS') AS convertedTime
from githubEvents
LIMIT 1
id | created_at_timestamp | timeInMs | convertedTime |
|---|---|---|---|
7044874109 | 2018-01-01 11:00:00.0 | 1514804400000 | 1514804400000000 |
select id,
created_at_timestamp,
cast(created_at_timestamp AS long) AS timeInMs,
TIMECONVERT(created_at_timestamp, 'MILLISECONDS', 'NANOSECONDS') AS convertedTime
from githubEvents
LIMIT 1
id | created_at_timestamp | timeInMs | convertedTime |
|---|---|---|---|
7044874109 | 2018-01-01 11:00:00.0 | 1514804400000 | 1514804400000000000 |
Last modified 1yr ago