[jira] [Updated] (TRAFODION-2987) Add documentation of systimestamp and sysdate in sql manual
[ https://issues.apache.org/jira/browse/TRAFODION-2987?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Selvaganesan Govindarajan updated TRAFODION-2987: - Fix Version/s: (was: 2.3) 2.4 > 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.4 > > > 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 (v8.3.4#803005)
[jira] [Updated] (TRAFODION-2987) Add documentation of systimestamp and sysdate in sql manual
[ https://issues.apache.org/jira/browse/TRAFODION-2987?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming updated TRAFODION-2987: Fix Version/s: (was: 2.2.0) 2.3 > 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 >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)
