alamb opened a new issue, #3982: URL: https://github.com/apache/arrow-datafusion/issues/3982
**Is your feature request related to a problem or challenge? Please describe what you are trying to do.** As we add more full featured date/time support for DataFusion users need to be able to use the current time to calculate things like "all data in the last 5 hours" **Describe the solution you'd like** Support the `current_time` postgres function https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT Note I think we should avoid the `current_time(precision)` variant initially -- we can implement it as a follow on PR. **Describe alternatives you've considered** A clear and concise description of any alternative solutions or features you've considered. **Additional context** This is a feature request we got from an early (internal) user of InfluxDB IOx I believe this is a good first issue as you can follow the existing implementation of `now()` - [ ] Physical support: https://github.com/apache/arrow-datafusion/blob/f1322592046a7ea895820286a2ad16d934540d92/datafusion/physical-expr/src/functions.rs#L424-L429) and use the same `query_execution_start_time` field - [ ] Tests: https://github.com/apache/arrow-datafusion/blob/beeb631d0bb979e9b6826f6cd3eae2d0a24f471e/datafusion/core/tests/sql/timestamp.rs#L417 It would be a good exercise to add a new build in scalar function, physical planing support, and then tests Note this the same ticket exists for the `current_date` function https://github.com/apache/arrow-datafusion/issues/3981 -- 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]
