This is where it is calculated. https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/adapter/enumerable/RexImpTable.java#L3712
this leads to here: https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/util/BuiltInMethod.java#L517 [https://opengraph.githubassets.com/6af4884a9b80dd1ac5b81e610caea8c9e34bcc847d0e172706a503b58f4f1557/apache/calcite]<https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/util/BuiltInMethod.java#L517> calcite/core/src/main/java/org/apache/calcite/util/BuiltInMethod.java at main ยท apache/calcite<https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/util/BuiltInMethod.java#L517> Apache Calcite. Contribute to apache/calcite development by creating an account on GitHub. github.com Which leads to methods in org.apache..calcite.avatica.util.DateTimeUtils ________________________________ From: Cancai Cai <caic68...@gmail.com> Sent: Monday, August 26, 2024 7:22 AM To: dev@calcite.apache.org <dev@calcite.apache.org> Subject: Some doubts about date functions Hello, everyone in the Calcite community. Recently, I am working on https://issues.apache.org/jira/browse/CALCITE-6544 of Calcite. The date function seems to be a little different from other functions. I can't find where the final results of date_add and date_sub are calculated. I only see various cast conversions, which makes me a little confused. I don't know where I should limit the final result set. Can you give me some advice or some jira cases to learn from? Best wishes, Cancai Cai Warning: The sender of this message could not be validated and may not be the actual sender.
