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;