You'd have to reset the system clock on the test server, I believe.
Alternatively: wrap SYSDATE in a packaged function, then you could adjust the returned value any way you like like this:
Code:
create or replace package utils as
function currdate return date;
procedure set_offset( p_offset in number );
end;
/
create or replace package body utils as
g_offset number := 0;
function currdate return date
is
begin
return SYSDATE + g_offset;
end;
procedure set_offset( p_offset in number )
is
begin
g_offset := p_offset;
end;
end;
/
For example:
SQL> alter session set nls_date_format='DD-MON-YYYY HH24:MI
S';
Session altered.
SQL> select sysdate, utils.currdate
2 from dual;
SYSDATE CURRDATE
-------------------- --------------------
23-SEP-2003 14:18:32 23-SEP-2003 14:18:32
SQL> exec utils.set_offset(-3)
PL/SQL procedure successfully completed.
SQL> /
SYSDATE CURRDATE
-------------------- --------------------
23-SEP-2003 14:18:47 20-SEP-2003 14:18:47
Of course, by doing this you are introducing a call to a PL/SQL function, which could impact performance if used heavily in SQL statements.
dBforums
>
Sysdate
09-23-03, 08:37
Linear Mode
