Date Function needed

From: <klausk_at_my-dejanews.com>
Date: Tue, 30 Jun 1998 10:50:21 GMT
Message-ID: <6naftd$d44$1@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 Received on Tue Jun 30 1998 - 05:50:21 CDT