You can add 5 minutes to the sysdate from dual using this:
select to_char(sysdate + (3/864), 'DD-MON-YY:hh.mi.ss') from dual;
86400 seconds in a day. 300 seconds in five minutes. So add
300/86400 to one day.
Hope that helps.
|
Results 1 to 3 of 3
Thread: add 5 minutes to date fieldThreaded View
|
Click Here to Expand Forum to Full Width |