Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYSDATE shows wrong time ..How do I change it...
In article <7dan98$voi$1_at_nnrp1.dejanews.com>,
tim.mcconechy_at_runtime.dk wrote:
> When I do a :
> select to_char(sysdate,'yyyy-mm-dd hh:mm:ss') from dual
> TO_CHAR(SYSDATE,'YY
> -------------------
> 1999-03-24 01:03:01
>
> It shows the wrong time....
> But My System says it's 1:54
>
> I am running Windows NT....I thought it would use the system clock..
>
> What's up???
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
SYSDATE pulls the date/time from the server that the database is running on.
Are you on NT, and connecting to a different machine which has the database on
it? If your database is running on the same maching you're on, then I can't
figure why the date/time would be different since it's just pulling from the
machine it's on.
Tony Rodgers
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 24 1999 - 09:32:12 CST