Skip to content

Latest commit

 

History

History
103 lines (83 loc) · 3.13 KB

timeconvert.md

File metadata and controls

103 lines (83 loc) · 3.13 KB
Raw
description
This section contains reference documentation for the TIMECONVERT function.

TIMECONVERT

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.

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