Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Date calculation function

Re: Date calculation function

From: Frank Piron <empty_at_zero.nil>
Date: Wed, 12 Jan 2005 16:39:40 +0100
Message-ID: <opskhxsepwm0et4w@news.online.de>


Am Wed, 12 Jan 2005 14:59:48 GMT schrieb Randy Harris <randy_at_SpamFree.com>:

> Is there a function that will calculate a date based on a number of weeks
> offset from another date? Something like Add_Months, but for weeks
> (Add_Weeks?)
>
>

function Add_Weeks(Start_Date in date,

                    Weeks_To_Add in number) return date
is
begin
  return Start_Date + Weeks_To_Add * 7;
end Add_Weeks;
/

Regards,

-- 
Frank Piron,
defrankatkonaddot
(leftrotate two)
Received on Wed Jan 12 2005 - 09:39:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US