Re: How do we change Oracle's Time?

Glynn C Taylor (gtaylor_at_clark.net) wrote:
>How do we change Oracle's view of what time it is without re-installing
>o the database? The system time is correct, but when we select sysdate
>from dual, the time is off by 4 hours. Thanks in advance.

Oracle obtains what it thinks is the correct local time directly from your OS. What OS are you using and how are determining the OS time? In what time zone is your system?

/b

--
Bill Manry  -  IBM Products Division  -  Oracle Corporation
These are my opinions, not necessarily Oracle's.
Remove "." from "B.Manry" to email me.