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

From: Roy Brokvam <roy.brokvam_at_conax.com>
Date: Wed, 24 Mar 1999 13:58:41 +0100
Message-ID: <On5K2.166$dk3.485@news1.online.no>

tim.mcconechy_at_runtime.dk wrote in message <7dan98$voi$1_at_nnrp1.dejanews.com>...
>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

Check your format again, looking for mm

mm is 2-digit month
mi is 2-digit minute

Regards,

Roy Brokvam
roy.brokvam_at_conax.com Received on Wed Mar 24 1999 - 06:58:41 CST