INTERVAL « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. INTERVAL
1.Using the INTERVAL YEAR TO MONTH Type
2.INTERVAL YEAR(3) TO MONTH
3.INTERVAL DAY TO SECOND type to store time intervals measured in days and seconds
4.INTERVAL DAY(3) TO SECOND (4)
5.INTERVAL DAY TO SECOND
6.Use date time Interval type: interval day(1) to second(2)