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
SELECT ToDateTime(1639137263000, 'yyyy-MM-dd') AS dateTimeString
FROM ignoreMe
dateTimeString
2021-12-10
SELECT ToDateTime(
1639137263000,
'yyyy-MM-dd hh:mm:ss a'
) AS dateTimeString
FROM ignoreMe
dateTimeString
2021-12-10 11:54:23 AM
SELECT ToDateTime(
1639137263000,
'yyyy-MM-dd HH:mm:ss Z',
'CET'
) AS dateTimeString
FROM ignoreMe
dateTimeString
2021-12-10 12:54:23 +0100
Was this helpful?