Re: Sysdate Value

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 22 Jan 2006 17:06:37 -0500
Message-ID: <vqydnRi5qK5ynEnenZ2dnUVZ_sCdnZ2d@comcast.com>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1137967088.561045_at_jetspin.drizzle.com...
> Pria wrote:
>> Hi All
>>
>> I want to know how exactly 'select sysdate from dual' works. From where
>> Oracle brings in sysdate if the init parameter fixed_date do not have
>> any value set against it. I know it brings the server machine date time
>> and if it does then exactly how is sysdate pointed to bring in server
>> time when Oracle is installed. Is there a script or how does it goes.
>>
>> Thanks in advance
>> Priya
>
> What does SYSDATE have to do with init parameters or anything else you
> wrote? And, quite frankly, what is the point of the inquiry?

fixed_date init parameter:
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams073.htm

OP is probably guessing that if FIXED_DATE can be set to a fixed date, perhaps SYSDATE is configurable in other ways

++ mcs Received on Sun Jan 22 2006 - 16:06:37 CST