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.
Signature
TIMECONVERT(col, fromUnit, toUnit)
The supported units are as follows:
DAYS
HOURS
MINUTES
SECONDS
MILLISECONDS
MICROSECONDS
NANOSECONDS
Usage Examples
These examples are based on the Batch JSON Quick Start.
id
created_at_timestamp
timeInMs
convertedTime
7044874109
2018-01-01 11:00:00.0
1514804400000
17532
id
created_at_timestamp
timeInMs
convertedTime
7044874109
2018-01-01 11:00:00.0
1514804400000
420779
id
created_at_timestamp
timeInMs
convertedTime
7044874109
2018-01-01 11:00:00.0
1514804400000
1514804400
id
created_at_timestamp
timeInMs
convertedTime
7044874109
2018-01-01 11:00:00.0
1514804400000
1514804400000
id
created_at_timestamp
timeInMs
convertedTime
7044874109
2018-01-01 11:00:00.0
1514804400000
1514804400000000
id
created_at_timestamp
timeInMs
convertedTime
7044874109
2018-01-01 11:00:00.0
1514804400000
1514804400000000000
Last updated