Re: SETTING THE ORACLE DATE

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: Thu, 8 Apr 1999 21:00:00 +0200
Message-ID: <7ekhc2$8t8$1@news.worldonline.nl>

Try setting the following in the INIT.ORA file:

fixed_date = 01-JAN-2000

Not sure about the format, see the DBA-guide. (perhaps MM-DD-YYYY ?)

Good luck,

  Roelof

---

Roelof Schierbeek, DBA
Bytelife BV
The Hague, Holland
email: bytelife AT worldonline.nl
check out : http://home.worldonline.nl/~bytelife

> Basically, I need to know how to alter the
>Oracle clock so that SELECT SYSDATE FROM DUAL returns a date in 2000 (to
>whatever i set the Oracle clock to), instead of today's date.
>
>Any ideas will be greatly appreciated.
>
>Thanks,
>
>Suman
>Thank you once again.....Suman (sumanc_at_lucent.com)
Received on Thu Apr 08 1999 - 14:00:00 CDT