Re: SYSDATE - Y2K

Of course it IS possible, man. You just set fixed_date parameter (see manual) in your initSID.ora file and restart the instance. This sets your SYSDATE to the given date.

Adam

Screamer wrote:

> No way jose !!!
>
> Kai Sodemann <Kai.Sodemann_at_memo.ikea.com> wrote in message
> news:01bef908$8c616400$6e49100a_at_pc910-sode.seurope.ikea.com...
> > Hi,
> >
> > is it possible, to change the SYSDATE for the Oracle database
> > and not for the server, the database is on ?
> >
> > Or is it maybe possible to drop the function sysdate (is it internal ?)
> > and create a new one ?
> >
> > I need this info for Y2K test.
> >
> > Any idea is welcome.
> >
> > regards Kai
Received on Tue Sep 07 1999 - 05:53:16 CDT