fritzb opened a new issue #7489: URL: https://github.com/apache/pinot/issues/7489
ToDateTime(tsInMillis, pattern) converts epoch millis value to DateTime string represented by pattern. ToDateTime() is missing timezone support. This support is important for user who uses Business Intelligence, where the result will be directly visualize and must be represented in the local timezone instead of UTC. Proposal: 1. Support tz(<time zone>) in pattern 2. Have <time zone> as optional argument if the UDF supports optional argument. e.g. ToDateTime(tsInMillis, pattern[, timeZoneId]) Use case example, convert to local timezone of the aggregated timeColumn: SELECT a_column, ToDateTime(MIN(time_column), 'yyyy-MM-dd hh:mm:ss.SSS tz(America/Los_Angeles)') GROUP BY a_column Additional things to consider: Would ToDateTime work if the timeColumn data type is TIMESTAMP instead of LONG. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
