Add hour, minute and second to a date : Date Calculation Query « Select Query « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Select Query
  3. Date Calculation Query

Add hour, minute and second to a date

  
SQL>
SQL> select sysdate, sysdate+1/24, sysdate +1/1440, sysdate + 1/86400 from dual;








Related examples in the same category

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