Re: SYSDATE - Y2K

In article <7r2l8k$fm7$1_at_duke.telepac.pt>,   "Screamer" <mflopes_at_bigfoot.com> 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
>
>

FIXED_DATE lets you set a constant date that SYSDATE will always return instead of the current date.The format of the date is: 'YYYY-MM-DD-HH24:MI:SS'.
May be it will be usefull for your test.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 07 1999 - 06:12:45 CDT