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

Home -> Community -> Usenet -> c.d.o.misc -> Sysdate Value

Sysdate Value

From: Pria <Pria79_at_gmail.com>
Date: 22 Jan 2006 10:50:38 -0800
Message-ID: <1137955838.940198.224380@g43g2000cwa.googlegroups.com>


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 Received on Sun Jan 22 2006 - 12:50:38 CST

Original text of this message

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