alter session set time_zone = '+09:00';
alter session set nls_timestamp_tz_format = 'yyyy-mm-dd hh24:mi:ss';
select interval '123-2' year(3) to month from dual;
select current_timestamp
, current_timestamp + interval '123-2' year(3) to month from dual;
'Oracle > SQL Fundamentals I' 카테고리의 다른 글
11일차 # 9-27: FOREIGN KEY constraints (0) | 2012.04.18 |
---|---|
11일차 # 9-17: Constraints (0) | 2012.04.18 |
11일차 # 9-11: Datetime Data Type (0) | 2012.04.18 |
11일차 # 9-7: Default option (0) | 2012.04.18 |
11일차 # 9-6: Schema (0) | 2012.04.18 |