qstommyshu commented on issue #12342: URL: https://github.com/apache/datafusion/issues/12342#issuecomment-2811368679
Ah, looks like datafusion doesn't even support this `to_date('1970-01-01', 'yyyy-mm-dd');` in v46.0.1 ```SQL > select to_date('1970-01-01', 'yyyy-mm-dd'); Execution error: Error parsing timestamp from '1970-01-01' using format 'yyyy-mm-dd': input contains invalid characters ``` Which said we won't be able to fully support this query `select to_date('1970-01-01', 'yyyy-mm-dd') + 5;` even after the operator issue is sorted out. -- 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-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org