Jackie-Jiang commented on issue #4740: [New Transformation function] Presto compatible DateTrunc URL: https://github.com/apache/incubator-pinot/pull/4740#issuecomment-547195922 @agrawaldevesh I think I might have missed something? Within the same timezone (both input and output value in the same timezone), will `date_trunc` always return the same value? E.g. - Input value in timezone1, truncate the time in timezone1, output value in timezone 2: `timezone_convert(date_trunc('DAYS', input), timezone1, timezone2)` - Input value in timezone1, output value in timezone2, truncate the time in timezone2: `date_trunc('DAYS', timezone_convert(input, timezone1, timezone2))` If this does not work, and we need to have the timezone info, then I agree we should put at as an input field. We can make it optional and default to UTC.
---------------------------------------------------------------- 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. 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]
