Date Calculation Query « Select Query « Oracle PL / SQL

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
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