Re: SYSDATE shows wrong time ..How do I change it...

From: Andreas Vef <avf_at_gft.de>
Date: Thu, 25 Mar 1999 14:08:03 +0100
Message-ID: <36FA3533.74BB@gft.de>

Just use the correct format:

select to_char(sysdate,'yyyy-mm-dd hh:mi:ss') from dual

                                      ^^that's the difference

MM is the format for month
MI is the format for minute

        Andreas

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

--

---

Dr. Andreas Vef                            mailto:Andreas.Vef_at_gft.de
Software-Entwicklung                       Tel: 07724/9411-0
GFT  AG               			   Fax: 07724/9411-94
Leopoldstr. 1                              http://www.gft.de 

D-78112 St. Georgen Received on Thu Mar 25 1999 - 07:08:03 CST