Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

Column localtimestamp format a28

SQL> SQL> select localtimestamp from dual; LOCALTIMESTAMP --------------------------------------------------------------------------- 16-JUN-08 01.26.59.426000 PM 1 row selected. SQL> SQL> select localtimestamp, current_timestamp   2  from dual; LOCALTIMESTAMP --------------------------------------------------------------------------- CURRENT_TIMESTAMP ------------------------------------ 16-JUN-08 01.26.59.496000 PM 16-JUN-08 01.26.59.496000 PM -11:00 1 row selected. SQL> SQL> alter session set time_zone = '-08:00'; Session altered. SQL> SQL> select localtimestamp, to_char(sysdate, 'DD-MON-YY HH:MI:SS AM') "SYSDATE"   2  from dual; LOCALTIMESTAMP                                                              SYSDATE --------------------------------------------------------------------------- --------------------- 16-JUN-08 04.26.59.686000 PM                                                16-JUN-08 05:26:59 PM 1 row selected. SQL> SQL> --