Apache Pinot Docs
latest
Search…
⌃K

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