Re: PO7 Time is wrong

In article <41ag4a$pvk_at_meaddata.meaddata.com> erwin_at_meaddata.com (Erwin Grunwald) writes:

> 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?

I've seen this all the time! :) I bet you're running this in August...

The problem is that MM is the format mask for month in numeric digits, and not the format mask for the current minute. The correct format mask is HH:MI:SS.

--
 Alvin W. Law ........................................... Oracle Corporation
 Project Leader ............................. 300 Oracle Parkway, Box 659305
 Applications Design & Architecture ............... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ...... Voice: +1.415.506.8317 . Fax: +1.415.506.7294

******************************** W a r n i n g ******************************
Microsoft Network is prohibited from reproducing this work in any form, in
whole or in part, without the express written consent of the original author.