liukun4515 commented on issue #4761: URL: https://github.com/apache/arrow-datafusion/issues/4761#issuecomment-1367880469
> @liukun4515 reg to postgres the conversion happens through timestamp, opposite to spark > > ``` > explain verbose SELECT now() = '2020-1-1' > > Output: (now() = '2020-01-01 00:00:00+00'::timestamp with time zone) > ``` > > Edit: this is for string literal for date it is > > ``` > explain verbose SELECT now() = '2020-1-1'::date > > Output: (now() = '2020-01-01'::date) > ``` Thanks for your effort for that, but I need some time to investigate time/data in PG and spark. I will reply and summary the behavior of them in a few days. -- 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]
