Re: Sysdate Value

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 22 Jan 2006 19:37:38 -0500
Message-ID: <EM-dnZMaRdzIuEneRVn-vw@comcast.com>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1137974368.337401_at_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)

if it was at the session level, it would make more sense -- somewhere i ran across a reference that indicates it was deprecated after v6, but that doesn't seem to be the case the was it's documented in 10gR2.

sure does give the devious DBA tempting thoughts though... could give a whole new meaning to 'flashback query'

++ mcs Received on Sun Jan 22 2006 - 18:37:38 CST