cjj2010 commented on PR #4712: URL: https://github.com/apache/calcite/pull/4712#issuecomment-3701294017
> It was my oversight; I noticed that the results from pgsql are inconsistent with what you provided. The results you provided resemble the format of duckdb. please see [pgsql result](https://onecompiler.com/postgresql/448mx4y73). sql: > > ``` > SELECT AGE(timestamp '2020-01-01 00:00:10', timestamp '2023-12-25 00:00:00') FROM (VALUES (1)) t; > ``` > > current pr: > > ``` > -3 years -11 mons -23 days -23 hours -59 mins -50.0 secs > ``` > > pgsql: > > ``` > -3 years -11 mons -23 days -23:59:50 > ``` I will change the logic of this part later. Thank you for your reminder to make this logic more rigorous -- 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]
