Powered by GitBook

1 of 1

Loading...

ToDateTime

This section contains reference documentation for the ToDateTime function.

Converts from milliseconds to a formatted date-time string, based on the provided Joda-Time pattern.

Signature

ToDate(millis, pattern)
ToDate(millis, pattern, timezoneId)

Usage Examples

dateTimeString

dateTimeString

dateTimeString

SELECT ToDateTime(1639137263000, 'yyyy-MM-dd') AS dateTimeString
FROM ignoreMe

2021-12-10

2021-12-10 11:54:23 AM

2021-12-10 12:54:23 +0100

SELECT ToDateTime(
    1639137263000, 
    'yyyy-MM-dd hh:mm:ss a'
    ) AS dateTimeString
FROM ignoreMe

SELECT ToDateTime(
    1639137263000, 
    'yyyy-MM-dd HH:mm:ss Z',
    'CET'
    ) AS dateTimeString
FROM ignoreMe