Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sysdate Value

Re: Sysdate Value

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 22 Jan 2006 23:16:25 +0100
Message-ID: <i018t11m76d1djtggvreiolkcggf99n56r@4ax.com>


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 DBA
Received on Sun Jan 22 2006 - 16:16:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US