Mega Code Archive

 

Categories / Oracle PLSQL / Select Query

 

Add 30 seconds to current date

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