Oracle/SQL Fundamentals II
14일차 # dbtimezone vs. sessiontimezone
Bohemian life
2012. 4. 23. 22:36
alter session set time_zone = '+3:0';
select dbtimezone, sessiontimezone from dual;
alter session set time_zone = dbtimezone;
select dbtimezone, sessiontimezone from dual;
alter session set time_zone = local;
select dbtimezone, sessiontimezone from dual;
alter session set time_zone = 'Asia/Seoul';
select dbtimezone, sessiontimezone from dual;