Re: SYSDATE, how to fast-forward?

itimms_at_crcl.com.au (Ian Timms) wrote:
>We have a need to test payroll cycles and need some method of
>advancing the date used by the application. We have no
>control over how the front end application does its date
>handling, nor (for the most part) over the batch jobs run
>on the server. So how _should_ one advance the date to
>perform any valid testing of this kind of thing? Is it
>possible to set SYSDATE forward a number of days?

I'm not sure if this is what you mean, but you can perform standard arithmetic on dates, so selecting SYSDATE+20 would give the date in 20 days time, or ADD_MONTHS(SYSDATE,2) would give the date in 2 months time. Received on Tue Sep 03 1996 - 00:00:00 CEST