Yuan Liu created TRAFODION-2987:
-----------------------------------
Summary: Add documentation of systimestamp and sysdate in sql
manual
Key: TRAFODION-2987
URL: https://issues.apache.org/jira/browse/TRAFODION-2987
Project: Apache Trafodion
Issue Type: Documentation
Components: website
Affects Versions: 2.2.0
Reporter: Yuan Liu
Fix For: 2.2.0
We support both systimestamp and sysdate but they are no documented there.
Systimestamp is equal to current_timestamp, and sysdate is equal to
current_date.
>>select systimestamp from dual;
(EXPR)
--------------------------
2018-03-10 10:32:19.232949
--- 1 row(s) selected.
>>select sysdate from dual;
(EXPR)
----------
2018-03-10
--- 1 row(s) selected.
>>select current_timestamp from dual;
(EXPR)
--------------------------
2018-03-10 10:32:30.733581
--- 1 row(s) selected.
>>select current_date from dual;
(EXPR)
----------
2018-03-10
--- 1 row(s) selected.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
