-
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>
-
No wonder, you're looking for the month number in the time component instead of the minutes. Try "mm/dd/yyyy hh24:mi:ss"
-
