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

Home -> Community -> Usenet -> c.d.o.server -> Re: Change function sysdate by another

Re: Change function sysdate by another

From: andrey <akryshin_at_fors.ru>
Date: Thu, 04 Mar 1999 13:59:26 +0300
Message-ID: <36DE678E.CD6A0B3D@fors.ru>

fvernier wrote:

> I want to make a function whitch return sysdate or another date recorded in
> database.
> This function doesn't have parameter but a persistent variable is need for
> make choose
>
> Thanks
>
> F

The function sysdate is system function and you could not change it any way. You may try to set fixed date by appling parameter FIXED_DATE in init.ora. In this way the sysdate return fixed value, not depend on system time. Received on Thu Mar 04 1999 - 04:59:26 CST

Original text of this message

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