add_week function? 1

[Glowworm27]

Oracle had an Add_Month function, is there an Add_Week function?

Does anyone have an Add_Week function?

I need to be able to add and subtract weeks from a date variable.

Thanks in advance.
G

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net

 

[SantaMufasa]

George,

Here ya' go:

create or replace function add_weeks (date_in date, how_many number)
    return date
is
begin
    return date_in+(how_many*7);
end;
/
Function created.

Here are sample invocations and results:

col a heading "ADD_WEEKS|Result" format a20
select to_char(add_weeks(sysdate,2),'dd-MON-yyyy hh24:mi:ss') a from dual;

ADD_WEEKS
Result
--------------------
15-NOV-2005 08:57:25

select to_char(add_weeks(sysdate,-2),'dd-MON-yyyy hh24:mi:ss') a from dual;

ADD_WEEKS
Result
--------------------
18-OCT-2005 08:59:33

Let us know if this is what you wanted.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[Glowworm27]

Yeah that works for me :


George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net