ly923976094 commented on issue #3626: timezone problem URL: https://github.com/apache/incubator-pinot/issues/3626#issuecomment-450542039 yes , The following PQL statement 1 can specify the corresponding time zone with SIMPLE_DATE_FORMAT, but the time conversion of SIMPLE_DATEFORMAT is very time-consuming, so I want to use sentence 2 to convert the result of query to time, but the time zone cannot be defined pql1: select sum(total) from test group by dateTimeConvert(timestamp, '1:MILLISECONDS:EPOCH','1:MILLISECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd HH:mm:ss tz(Asia/Shanghai)', '1:DAYS') pql2: select sum(total) from test group by dateTimeConvert(timestamp, '1:MILLISECONDS:EPOCH','1:MILLISECONDS:EPOCH', '1:DAYS')
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
