Datetime Data Types (2)

• The INTERVAL YEAR TO MONTH data type stores a period of time using the YEAR and MONTH datetime fields
  INTERVAL YEAR [(year_precision)] TO MONTN
  ex)
  

  CREATE TABLE time_example2
  
  (loan_duration INTERVAL YEAR(3) TO MONTH );
  
  
  
  INSERT INTO time_example (loan_duration) 
  
   VALUE (INTERVAL '120' MONTH));
  
  
  
  
  
  SELECT TO_CHAR (sysdate +loan_duration, 'dd-mon-yyyy')
  
  FROM time_example2;
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

  
  
  
• The INTERVAL DAY TO SECOND data type stores a period of time in terms of days, hours, minutes, and seconds:
INTERVAL DAY [(day_precision)]
TO SECOND [(fractional_second_precision)]

ex)
INTERVAL '4 5:12:10.222' DAY TO SECOND(3)
-> Indicate 4 days, 5 hours, 12 minutes, 10 seconds, and 222 thousandths of a second.
INTERVAL '180' DAY(3) : Indicate 180 days

CREATE TABLE time_example3
(day_duration INTERVAL DAY(3) TO SECOND);

INSERT INTO time_example3 (day_duration)
VALUES (INTERVAL '180' DAY(3));

SELECT sysdate + day_duration "Half Year"
FROM time_example3;