Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: changing system date

Re: changing system date

From: <gparc_at_free.fr>
Date: Wed, 29 Jun 2005 11:08:09 +0200
Message-ID: <1120036089.42c264f9b8041@imp2-q.free.fr>


onkarnath,

to revert your change use :

SQL> alter system set fixed_date=none;

HTH Selon Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>:

> hi all,
> I had got one mail from the group wherein following command was given:
> alter session set nls_date_format='dd.mon.yyyy hh24:mi';
> alter system set fixed_date='<anydate>';
> this was used to change the server date and time without affecting the
> original date n time on the server but when I tried the command on the
> server(test obviously not the production one) then the date n time was
> changed and then it wasnt changing to its original value. So I had to
> re-start the oracle database. Why so?? any idea??? Is there any method using
> which we can revert it to the original value???
> Plz. suggest

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 29 2005 - 05:13:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US