Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SYSDATE - Y2K

Re: SYSDATE - Y2K

From: Adam Czopek <acz_at_pro.onet.pl>
Date: Tue, 07 Sep 1999 12:53:16 +0200
Message-ID: <37D4EE9C.38960EB@pro.onet.pl>


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

Original text of this message

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