oracle查看当前时间

查看当前系统时间和timestamp

SQL> show user
User is "ls_qudao" 
SQL>
SQL> SELECT TO_CHAR(SYSDATE,'YYYYMMDD HH24:MI:SS') "sysdate",
  2         SYSTIMESTAMP,
  3         TO_CHAR(CURRENT_DATE,'YYYYMMDD HH24:MI:SS') "currentdate",
  4         CURRENT_TIMESTAMP,
  5         DBTIMEZONE,
  6         SESSIONTIMEZONE
  7  FROM   DUAL;
 
sysdate                            SYSTIMESTAMP                                                   currentdate                      CURRENT_TIMESTAMP                                                                DBTIMEZONE SESSIONTIMEZONE
-----------------                 -----------------------------------------------                  ---------------------           ----------------------------------------------------------- ---------- ---------------------------------------------------------------------------
20111026 15:03:34   26-10月-11 03.03.34.723321 下午 +08:00           20111026 15:03:35             26-10月-11 03.03.34.723323 下午 +08:00            +08:00   

  +08:00