¡¼Çü½Ä¡½
      CURRENT_TIMESTAMP [(precision)]

¡¼¿¹Á¦¡½
SQL> alter SESSION SET TIME_ZONE = '-5:0';

Session altered.

SQL> select CURRENT_TIMESTAMP, LOCALTIMESTAMP, CURRENT_DATE from dual;

CURRENT_TIMESTAMP
---------------------------------------------------------------------------
LOCALTIMESTAMP
---------------------------------------------------------------------------
CURRENT_DATE
-----------------------
21-FEB-09 11.43.17.482812 PM -05:00
21-FEB-09 11.43.17.482812 PM
21-FEB-2009 23:43:17

SQL> alter session set NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';

Session altered.

SQL> select SESSIONTIMEZONE, CURRENT_TIMESTAMP from dual;

SESSIONTIMEZONE
--------------------------------------------------------------------------------
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
-05:00
21-FEB-09 11.46.00.025039 PM -05:00

SQL> alter SESSION SET TIME_ZONE = '+9:0';

Session altered.

SQL> select SESSIONTIMEZONE, CURRENT_TIMESTAMP from dual;

SESSIONTIMEZONE
--------------------------------------------------------------------------------
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
+09:00
22-FEB-09 01.48.01.701289 PM +09:00

SQL> 

¡¼¿¹Á¦¡½
SQL> create table current_test(aa TIMESTAMP WITH TIME ZONE);

Table created.

SQL> insert into current_test values(
  2    TO_TIMESTAMP_TZ(CURRENT_TIMESTAMP, 'DD-MON-RR HH.MI.SSXFF PM TZH:TZM'));

1 row created.      ¢Ð  current_timestampÀÇ Æ÷¸ËÀÌ ÀÏÄ¡ÇϹǷΠ¿À·ù°¡ ¾øÀ½

SQL> select * from current_test;

AA
---------------------------------------------------------------------------
22-FEB-09 01.57.29.382050 PM +09:00

SQL> insert into current_test values(
  2    TO_TIMESTAMP_TZ(CURRENT_TIMESTAMP, 'DD-MON-RR HH.MI.SSXFF PM'));
  to_timestamp_tz(current_timestamp, 'DD-MON-RR HH.MI.SSXFF PM'))
                  *
ERROR at line 2:     ¢Ð current_timestampÀÇ Æ÷¸ËÀÌ ÀÏÄ¡ÇϹǷΠ¿À·ù°¡ ¹ß»ý
ORA-01830: date format picture ends before converting entire input string


SQL>