RE: Add_Month... Add_Hour? Add_Minute?

[Naveen Nahata]

if you do a_date + n, it increments a_date(if it is of datatype DATE) by 'n' days.   So to_date('04-OCT-2002', 'DD-MON-YYYY') + 1 = to_date('05-OCT-2002', 'DD-MON-YYYY')   If you want to increment one hour add 1/24, if you want to increment by 1 min. add 1/(60*24) and so on   Regards Naveen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 1:13 PM To: Multiple recipients of list ORACLE-L Subject: Add_Month... Add_Hour? Add_Minute? Hi Gurus,   i know there's 'add_month', is there any built-in function like 'add_hour' or 'add_minute'? or i have to write a function to add it?   thanks in advance.