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

+ Recent posts