Re: [I] date_trunc incorrect results in non-UTC timezone [datafusion-comet]

["andygrove (via GitHub)" <gi...@apache.org>]

andygrove commented on issue #2649:
URL: https://github.com/apache/datafusion-comet/issues/2649#issuecomment-3503993365

   I have a smaller repro: 
   ```scala
   test("sort on timestamp after changing session timezone") {
       // create data in specific timezone
       withSQLConf(SQLConf.SESSION_LOCAL_TIMEZONE.key -> "Europe/London") {
         createTimestampTestData.createOrReplaceTempView("tbl")
       }
       // read data in a different timezone
       withSQLConf(SQLConf.SESSION_LOCAL_TIMEZONE.key -> "America/Denver") {
         checkSparkAnswerAndOperator("SELECT c0 FROM tbl ORDER BY c0")
       }
     }
   ```


-- 
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: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org