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? -- //www.freelists.org/webpage/oracle-l