Add time to a date/time format

Hi!
How can I add minutes to a date/time format for retrieve or insert rows?

I mean, actually I have a row with '2004-10-15 13:04:03' and I would like to update that row to add 5 minutes. How can I make it?

Thanks

Machinx,

Assuming that the field which you want to update is a date type field you should be able to add 5 mins by " + 5/60/24"

your update statement would be something like this

update <table_name> set <your_date_field> = <your_date_field>+ 5/60/24 ;

if you your field is not a date you can always convert it using to_date.

hth,

jiggee