Re: Sysdate Value

From: EdStevens <quetico_man_at_yahoo.com>
Date: 23 Jan 2006 09:14:37 -0800
Message-ID: <1138036476.983350.26530@g44g2000cwa.googlegroups.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

Sybrand is right about the reverse engineering. However, I would assume that Oracle gets the current system date/time the same way any other application would -- by calling a specific routine provided by the OS just for that purpose. Received on Mon Jan 23 2006 - 11:14:37 CST