Date Calculation Query « Select Query « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Select Query
  3. Date Calculation Query
1.Add hour, minute and second to a date
2.Add 30 seconds to current date
3.Using arithmetic operators with date values
4.To find the date of the Friday after each start date
5.NEXT_DAY(start_date-1,'Tuesday')
6.Date + to_yminterval('01-05')
7.start_date+TO_DSINTERVAL('100 10:00:00')
8.Born after 1965-01-01
9.Convert string based date variable to date type during when comparing