I think it's just that there is no need for a function as hour, minute and second are always known fractions of a day i.e 1/24, 1/1440, 1/86400 whereas month is variable. Given that a functions seems a bit excessive. Iain Nicoll
-----Original Message----- Sent: Thursday, October 03, 2002 8:43 AM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain \(Calanais\) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).