查看当前系统时间和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