cjj2010 commented on PR #4712: URL: https://github.com/apache/calcite/pull/4712#issuecomment-3701292664
> 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 used multiple clients to verify this issue again and found that The values returned by navicat, dbeaver, and pgadmin are -3 years -11 mons -23 days -23:59:50, as shown in the data grid -3 years -11 mons -23 days -23 hours -59 mins -50.0 secs， In this situation, I agree that the format you mentioned should be used -- 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]
