niebayes opened a new issue, #12891: URL: https://github.com/apache/datafusion/issues/12891
### Is your feature request related to a problem or challenge? Say there's a table consisting of a timestamp column with the precision seconds. If we can support type coercion between timestamp and unixtime, a query `SELECT * FROM tbl WHERE ts > 1723527660` would be regarded legal and there's no need to wrap the unixtime with the function `from_unixtime`. ### Describe the solution you'd like Add a cast path between timestamp and unixtime, and try to cast a integer to a certain timestamp type when building a plan. Reports an error when such a cast fails. ### Describe alternatives you've considered _No response_ ### Additional context _No response_ -- 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]
