[
https://issues.apache.org/jira/browse/CALCITE-6666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17895482#comment-17895482
]
Mihai Budiu commented on CALCITE-6666:
--------------------------------------
Fixed in
https://github.com/apache/calcite/commit/7fb0fc26bdd067a1ce292cfe1642961fa2d1dc41
Thank you for your contribution [~duanzhengqiang]
Thank you for the review [~caicancai]
> Support Oracle SYSDATE and SYSTIMESTAMP functions
> -------------------------------------------------
>
> Key: CALCITE-6666
> URL: https://issues.apache.org/jira/browse/CALCITE-6666
> Project: Calcite
> Issue Type: Improvement
> Reporter: Zhengqiang Duan
> Assignee: Zhengqiang Duan
> Priority: Major
> Labels: pull-request-available
>
> Hi community. When I execute sql with Oracle SYSDATE and SYSTIMESTAMP
> functions, the following error message appears.
> {code:java}
> SELECT SYSDATE FROM SBTEST1 WHERE ID = 12345600
> // Caused by: org.apache.calcite.runtime.CalciteContextException: From line
> 1, column 8 to line 1, column 14: Column 'SYSDATE' not found in any table
> SELECT SYSTIMESTAMP FROM SBTEST1 WHERE ID = 12345600
> // Caused by: org.apache.calcite.runtime.CalciteContextException: From line
> 1, column 8 to line 1, column 19: Column 'SYSTIMESTAMP' not found in any
> table {code}
> I checked the Oracle official documentation and found that SYSDATE and
> SYSTIMESAMP functions are similar to CURRENT_DATE and CURRENT_TIMESTAMP. I
> think we can quickly adapt to support them.
> Here is the documentation for the Oracle SYSDATE and SYSTIMESTAMP functions:
> -
> [https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SYSDATE.html]
> -
> [https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SYSTIMESTAMP.html]
> Refer to this article -
> [https://database-heartbeat.com/2021/09/28/sysdate-vs-current_date-in-oracle-database/],
> he describes the difference between SYSDATE, SYSTIMESTAMP functions, and
> CURRENT_DATE, CURRENT_TIMESTAMP: SYSDATE is a SQL function that returns the
> current date and time set for the operating system of the database server.
> CURRENT_DATE returns the current date in the session time zone. The same
> story applies to SYSTIMESTAMP and CURRENT_TIMESTAMP.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
