Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sysdate Value
On 22 Jan 2006 10:53:24 -0800, "Pria" <Pria79_at_gmail.com> 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
Your question would require reverse engineering which explicitly
forbidden by your license.
Why do you want to know this?
-- Sybrand Bakker, Senior Oracle DBAReceived on Sun Jan 22 2006 - 16:16:25 CST