Re: How to change the value of Sysdate

  • From: David Sharples <davidsharples@xxxxxxxxx>
  • To: Nagarajan.Subbiah@xxxxxxxx
  • Date: Mon, 27 Jun 2005 20:45:49 +0100

alter session set nls_date_format = 'dd.mon.yyyy hh24:mi:ss';
alter system set fixed_date='2004-03-02 22:23:24';
select sysdate from dual;

On 6/27/05, Subbiah, Nagarajan <Nagarajan.Subbiah@xxxxxxxx> wrote:

> I believe few days back there was a discussion of changing the sysdate value
> to the desired date with out changing the date value on the server and
> someone had given the procedure to do it. Can anyone of you send the
> procedure?

Other related posts: