DBTIMEZONE ÇÔ¼ö

µ¥ÀÌÅͺ£À̽º timezoneÀ» ¹ÝȯÇÑ´Ù.
¿À¶óŬ µ¥ÀÌÅͺ£À̽º°¡ óÀ½ »ý¼ºµÉ ¶§ ¿î¿µÃ¼Á¦·ÎºÎÅÍ È®ÀÎµÈ ½Ã°¢Á¤º¸ÀÌ´Ù.
¹ÝȯµÇ´Â µ¥ÀÌÅÍŸÀÔÀÇ timezone offsetÀº
character µ¥ÀÌÅÍŸÀÔ¿¡¼­ '[+ ¦ -] TZH:TZM'À¸·Î ÁöÁ¤ÇÑ Æ÷¸ËÀ¸·Î ¹ÝȯµÇ°Å³ª,
¶Ç´Â timezone region nameÀ» ¹ÝȯµÈ´Ù.
ALTER DATABASE ¸í·É¾î¸¦ »ç¿ëÇÏ¿© DBÀÇ timezoneÀ» º¯°æÇÒ ¼ö ÀÖ´Ù.

¡¼Çü½Ä¡½
     DBTIMEZONE

¡¼¿¹Á¦¡½
SQL> select DBTIMEZONE from dual;

DBTIME
------
-07:00

SQL> select SESSIONTIMEZONE from dual;

SESSIONTIMEZONE
--------------------------------------------------------------------------
+09:00

SQL> 
SQL> select TZ_OFFSET(SESSIONTIMEZONE) from dual;
 
TZ_OFFS
-------
+09:00
 
SQL> select TZ_OFFSET(DBTIMEZONE) from dual;
 
TZ_OFFS
-------
+00:00
 
SQL>