alamb opened a new issue, #7868: URL: https://github.com/apache/arrow-datafusion/issues/7868
### Is your feature request related to a problem or challenge? In https://github.com/apache/arrow-datafusion/pull/7844 we are (about to) change `to_timestamp` to be aligned with postgres by taking seconds instead of milliseconds. To fully align with postgres, we should also add support `double` (`Float64`) arguments as well The postgres documentation for `to_timestamp` is [here](https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-TABLE) ### Describe the solution you'd like I would like the `to_timestamp` function to also support Float64 point arguments: For example, (not the `1.1` at the end of the timestamp) ```bash willy=# select to_timestamp(1.1); to_timestamp -------------------------- 1970-01-01 08:00:01.1+08 ``` ### Describe alternatives you've considered _No response_ ### Additional context Note the string / two argument version of `to_timestamp` is covered by https://github.com/apache/arrow-datafusion/issues/5398 -- 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]
