Add 30 seconds to current date : Date Calculation Query « Select Query « Oracle PL / SQL

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




Add 30 seconds to current date

  

select sysdate NOW, sysdate+30/(24*60*60) NOW_PLUS_30_SECS from dual;

Related examples in the same category

1.Add hour, minute and second to a 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