Re: PO7 Time is wrong

erwin_at_meaddata.com (Erwin Grunwald) wrote:

>I just got the 90-day PO7 (7.1.4) CD. I notice that when I
>query the database using:
 

>select to_char(sysdate,'MM/DD/YY HH:MM:SS') from dual;
 

>The time is not correct! For example:
 

>PC Time select to_char(sysdate,'....
>1:15 1:08
>2:30 2:08
>5:45 5:08
 

>Very strange! Has anyone else seen this?
>
 

>--
> Erwin T. Grunwald (B5/F3/IF) erwin_at_scooter.lexis-nexis.com
> LEXIS-NEXIS !uunet!lexis-nexis!erwin
> A member of the Reed Elsevier Plc group
> P.O. Box 933
> Dayton, OH. 45401 Make things as simple as possible
> 865-6800 x4742 - but no simpler. -- Albert Einstein
 

> <a href="http://www.lexis-nexis.com/~erwin">erwin's home page</a>

You are using the wrong format string. MM is numeric month (08 is August). Use MI for minutes.

Jim Smith                      jim_at_jimsmith.demon.co.uk
Oracle DBA