Re: Date function needed

If you are comparing dates, and not date-times, remember to use trunc().

In article <6nah4n$rcb$1_at_mailgate.ikea.com>,   "Joachim Carlsson" <no_spam_joachim.carlsson_at_neurope.ikea.com> wrote:
>
> You can do sysdate + 1000 without problem.
>
> Regards
> /Joachim
> klausk_at_my-dejanews.com wrote in message <6nafmp$csp$1_at_nnrp1.dejanews.com>...
> >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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jun 30 1998 - 13:54:21 CDT