change the TZ environment variable in your unix session :
eg, we have TZ=MET here
$ date
Tue Jul 4 06:57:15 MET DST 2000
$ export TZ=MET+8782
$ date
Sun Jul 4 06:57:22 MET 1999
$ sqlplus system
...
SQL> alter session set nls_date_format='YYYY-MON-DD HH24:MI:SS';
session altered.
SQL> select sysdate from dual;
SYSDATE
1999-JUL-04 06:58:29
> ----------
> From: Jay Weinshenker[SMTP:jweinshe_at_concentric.net]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, June 29, 2000 20:35
> To: Multiple recipients of list ORACLE-L
> Subject: FIXED_DATE parameter and incrementing time...
>
> Heya.
>
> For reasons better left unexplained, I have a server which runs at the
> real
> time (6/29/2000), but I have one database which I need to run as if it's
> 1999 (sounds like a Prince song). Anyhow, I know I can use the FIXED_DATE
>
> init.ora/alter system parameter to change the database's timedate to a
> specific date time down to the second.
>
> HOWEVER, this timestamp won't increment. IE, It will stay the exact same
> time all day... this is the problem I am trying to work around. I would
> like for the date part of the clock to stay at whatever date I set it, but
>
> I want the time to increment normally...
>
> Anyone have any tips/ideas on doing this? The database resides on
> Solaris,
> so I'm currently considering looking at writing a daemon which will
> connect
> to the database and issue alter system set fixed_date = .... commands each
>
> second, but this is a really ugly and inefficient solution, so I'm hoping
> someone has something better...
>
> Thanks in advance..
>
> J
>
> p.s. Yes, I thought about using a cron job, but cron's granularity is
> down
> to the minute...
>
> --
> Author: Jay Weinshenker
> INET: jweinshe_at_concentric.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jul 04 2000 - 00:05:56 CDT
