Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Change function sysdate by another
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