Re: changing time in Database

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 26 Jul 1999 13:55:23 GMT
Message-ID: <7nhpcb$ssi$2@news.seed.net.tw>

Eric <ericsanandres_at_hotmail.com> wrote in message news:379785D5.C9948FF5_at_hotmail.com...
> hello gurus,
>
> can you change time/date in the database without changing the OS system
> time/date?

There is a strange statement ALTER SYSTEM SET FIXED_DATE='yyyy/mm/dd hh24:mi:ss' to change the time of the database.
After issuing the statement, the time of the database is frozen, and I don't know how to reset the time unless restarting the database. Received on Mon Jul 26 1999 - 08:55:23 CDT