Klaus Koeser wrote on SYSDATE -1 :
add 1000 days to sysdate is: ???? <in date format>
SYSDATE + 1000
add -545 days to sysdate is: ???? <in date format>
SYSDATE - 545
Tip:
Take a look at the ate conversion functions; You can perform any
trick you want with
al little programming skills.
> -----Original Message-----
> From: klausk_at_my-dejanews.com [SMTP:klausk_at_my-dejanews.com]
> Posted At: dinsdag 30 juni 1998 12:50
> Posted To: misc
> Conversation: Date Function needed
> Subject: Date Function needed
>
> Hi,
>
> I'm looking for a function to add or subtract days to a given date
> (usually
> sysdate), and have the new date returned:
>
> add 1000 days to sysdate is: ???? <in date format>
> add -545 days to sysdate is: ???? <in date format>
>
> in Transact SQL there is a date_add function, which allows to add
> integer
> values to each specified datepart, Oracle unfortunately hasn't.
>
>
> the add_months function doesn't fullfil the requirements
>
> Every help appreciated !
>
> Thx
>
> Klaus Kloeser
>
> -----== Posted via Deja News, The Leader in Internet Discussion
> ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member
> Forum
Received on Thu Jul 02 1998 - 13:00:12 CDT
