Oracle/SQL Fundamentals I
11일차 # 9-14: Interval
Bohemian life
2012. 4. 18. 17:36
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;