Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-2987

Add documentation of systimestamp and sysdate in sql manual

    XMLWordPrintableJSON

Details

    • Documentation
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 2.2.0
    • 2.4
    • website
    • None

    Description

      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.

      Attachments

        Activity

          People

            Liu Yu 66 Liu Yu
            Yuan_Liu Yuan Liu
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: