1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| SQL> alter session set NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS';
Session altered.
SQL> select current_timestamp,localtimestamp,sysdate,systimestamp from dual;
CURRENT_TIMESTAMP
LOCALTIMESTAMP
SYSDATE
SYSTIMESTAMP
27-SEP-20 03.42.56.895320 PM +08:00 27-SEP-20 03.42.56.895320 PM 27-SEP-2020 15:42:56 27-SEP-20 03.42.56.895316 PM +08:00
SQL> alter session set time_zone='-5:00';
Session altered.
SQL> select current_timestamp,localtimestamp,sysdate,systimestamp from dual;
CURRENT_TIMESTAMP
LOCALTIMESTAMP
SYSDATE
SYSTIMESTAMP
27-SEP-20 02.43.39.911368 AM -05:00 27-SEP-20 02.43.39.911368 AM 27-SEP-2020 15:43:39 27-SEP-20 03.43.39.911363 PM +08:00
|