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...
The problem is the format string: it must be yyyy-mm-dd hh:mi:ss.
Mind the mi. Minutes is represented by mi not bei mm. As you can see in
your own string this is
already used for months. So it shows alway 01:03:01 because we have march
which is the third month of the year.
> 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
Received on Wed Mar 24 1999 - 07:10:58 CST
![]() |
![]() |