I have two date fields in one of my table:
Test_Date_1 and Test_Date_2
I need to add 5 minutes to Test_Date_2 field. (Test_Date_1 + 5 minutes)
Could anybody send me correct UPDATE SQL example which can do this?
thanks!
Printable View
I have two date fields in one of my table:
Test_Date_1 and Test_Date_2
I need to add 5 minutes to Test_Date_2 field. (Test_Date_1 + 5 minutes)
Could anybody send me correct UPDATE SQL example which can do this?
thanks!
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.
that was very slick,,
good input