Oracle-L: RE: Add_Month... Add_Hour? Add

From: Nicoll, Iain \(Calanais\) <iain.nicoll_at_calanais.com>
Date: Thu, 03 Oct 2002 01:28:36 -0800
Message-ID: <F001.004DF075.20021003012836@fatcity.com>

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: iain.nicoll_at_calanais.com

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: ListGuru_at_fatcity.com (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). Received on Thu Oct 03 2002 - 04:28:36 CDT

RE: Add_Month... Add_Hour? Add_Minute?