hpvd commented on issue #13004: URL: https://github.com/apache/pinot/issues/13004#issuecomment-2077021356
`Example: TIMESTAMP '2001-08-22 03:04:05.321 America/Los_Angeles'` I'm a little unsure if this format may not lead to confusion. The problem I see when using these values is, that Dayllight saving time (DST) / summer and winter time is not reflected in this. Since summer and winter time is not aligned all over the world, see https://en.wikipedia.org/wiki/Daylight_saving_time_by_country some calculations on base of these values may get complicate/prone to errors. One approach to solve this may be adding `UTC+X` to timestamp instead Example: TIMESTAMP '2001-07-23 03:04:05.321 UTC+2' -> Germany/Berlin/summertime TIMESTAMP '2001-12-24 03:04:05.321 UTC+1' -> Germany/Berlin/wintertime -- 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: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
