SYSDATE, how to fast-forward?

From: Ian Timms <itimms_at_crcl.com.au>
Date: 1996/09/03
Message-ID: <50h1p1$890_003_at_crcl.com.au>#1/1

Hi,

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? Advancing the machines date is not an option as it's used for other development, so what _do_ people do in this situation?

I've had one response indicating that fixed_date might be used in the init.ora, but I don't think I want it fixed, what I want is to fast-forward.

Cheers, Ian.

PS. Emailed responses to itimms_at_csc.com.au, would be appreciated.

Cheers, Ian.

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%


% Ian Timms                 [Team OS/2] % Disclaimer: All opinions expressed  %

% itimms_at_ariel.ucs.unimelb.edu.au       % herein are mine and mine alone! ;-) %

% CIS: 100236,1404 IBM: itimms_at_ibm.net % ===__( The author of RxAsync )__=== %

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Received on Tue Sep 03 1996 - 00:00:00 CEST