[ https://issues.apache.org/jira/browse/TRAFODION-2987?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liu ming reassigned TRAFODION-2987: ----------------------------------- Assignee: Liu Yu > 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 > Assignee: Liu Yu > Priority: Major > Fix For: 2.3 > > > 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)