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: How to change the value of Sysdate

Re: How to change the value of Sysdate

From: Ram K <lambu999_at_gmail.com>
Date: Wed, 29 Jun 2005 16:10:26 -0700
Message-ID: <db3c8dbf050629161053716523@mail.gmail.com>


I was playing around with setting the fixed_date. I was able to set it to some other date. But I cant set it back to current date (sysdate).  Tried googling for 'unsetting fixed_date', 'setting sysdate' - did not get any useful link....

Thanks.

On 6/29/05, David Sharples <davidsharples_at_gmail.com> wrote:
> because it was typed wrong :-)
>
> On 6/29/05, JayMiller_at_tdwaterhouse.com <JayMiller_at_tdwaterhouse.com> wrote:
> > Is there a reason the nls_date_format and fixed_date don't match in the
> > example below?
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Thanks,
Ram.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 29 2005 - 19:15:50 CDT

Original text of this message

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