Re: Sysdate Value

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 22 Jan 2006 15:59:29 -0800
Message-ID: <1137974368.337401@jetspin.drizzle.com>

Mark C. Stock wrote:
> "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

And I thought I was spending way too much time studying the backroads of Oracle. I can't think of one reason why I would ever want a parameter that does this. Even with the caveat of it being for testing. Yech!

Thanks.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Sun Jan 22 2006 - 17:59:29 CST