add 5 minutes to date field

[Eberman]

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!

[dknight]

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.

[hbk_emp]

that was very slick,,
good input