dqkqd commented on issue #18062: URL: https://github.com/apache/datafusion/issues/18062#issuecomment-3403649357
I run `datafusion-cli` on main. `current_date` returns expected behavior as introduced in the PR. It changes based on timezone. ``` > SET datafusion.execution.time_zone = '+00:00'; 0 row(s) fetched. Elapsed 0.001 seconds. > select current_date(); +----------------+ | current_date() | +----------------+ | 2025-10-14 | +----------------+ 1 row(s) fetched. Elapsed 0.004 seconds. > SET datafusion.execution.time_zone = '+05:00'; 0 row(s) fetched. Elapsed 0.001 seconds. > select current_date(); +----------------+ | current_date() | +----------------+ | 2025-10-15 | +----------------+ 1 row(s) fetched. Elapsed 0.004 seconds. ``` But `now` doesn't. ``` DataFusion CLI v50.2.0 > SET datafusion.execution.time_zone = '+00:00'; 0 row(s) fetched. Elapsed 0.003 seconds. > select now(); +--------------------------------+ | now() | +--------------------------------+ | 2025-10-14T21:16:57.781868096Z | +--------------------------------+ 1 row(s) fetched. Elapsed 0.005 seconds. > SET datafusion.execution.time_zone = '+05:00'; 0 row(s) fetched. Elapsed 0.001 seconds. > select now(); +--------------------------------+ | now() | +--------------------------------+ | 2025-10-14T21:17:02.014016475Z | +--------------------------------+ 1 row(s) fetched. Elapsed 0.003 seconds. > ``` Might require #17993 to make the test work. -- 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]
