gargvishesh commented on issue #12434:
URL: https://github.com/apache/druid/issues/12434#issuecomment-1730947411

   @lingguang I'm working to put in the fix for this. 
   
   In the example you posted, if we convert the values to GMT times, none of 
the outputs among `-14D-7D` and `-21D` seem correct.
   
   GMT Times:
   origin  2022-03-27T08:35:00.000Z
   -21D(expected) 2022-03-06T09:35:00.000Z
   -14D 2022-03-13T09:35:00.000Z
   -14D-7D 2022-03-06T10:35:00.000Z
   
   To maintain correct `7D` bucket sizes, the correct `-21D` GMT time should 
rather be `2022-03-06T08:35:00.000Z`, which converted to `America/Denver` 
timezone -- taking into account DST transition -- becomes 
`2022-03-06T01:35:00.000-07:00`.  Do you agree with this?


-- 
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]

Reply via email to