sysdate?very weird problem

[ocpdude]

Here is the problem.

I am working on the development box locally.
when I login using sqlplus I get the right date on the login info 14:18:35 2002
and wrong date when I use sysdate 14:07:30 !
now, no matter when I select sysdate I always get the minutes = 07. I checked the system clock on the server
and it is working fine. any idea !!!!!!!


SQL*Plus: Release 8.0.6.0.0 - Production on Thu Jul 18 14:18:35 2002

(c) Copyright 1999 Oracle Corporation. All rights reserved.


Connected to:
Oracle8i Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production

SQL> select to_char(sysdate, 'dd-mon-yy hh24:mm:ss') from dual;

TO_CHAR(SYSDATE,'D
------------------
18-jul-02 14:07:30

TO_CHAR(SYSDATE,'D
------------------
18-jul-02 14:07:30

SQL> /

TO_CHAR(SYSDATE,'D
------------------
18-jul-02 14:07:31

SQL> /

TO_CHAR(SYSDATE,'D
------------------
18-jul-02 14:07:41

SQL> /

TO_CHAR(SYSDATE,'D
------------------
18-jul-02 14:07:41

SQL> /

TO_CHAR(SYSDATE,'D
------------------
18-jul-02 14:07:42

SQL>

[marist89]

No wonder, you're looking for the month number in the time component instead of the minutes. Try "mm/dd/yyyy hh24:mi:ss"

[ocpdude]

Thanks