RE: Add_Month... Add_Hour? Add_Minute?

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Thu, 03 Oct 2002 01:23:26 -0800
Message-ID: <F001.004DF010.20021003012326@fatcity.com>

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-----
Sent: Thursday, October 03, 2002 1:13 PM 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: Naveen Nahata
  INET: naveen_nahata_at_mindtree.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:23:26 CDT