Hi All DBAs,

Could some one explain why the following SQL is not
returning HH:MI:SS?

SQL> select to_date(sysdate,'DD-MON-YYYY HH:MI:SS')
from dual;

TO_DATE(S
---------
29-MAR-03

SQL> select to_char(sysdate,'DD-MON-YYYY HH:MI:SS')
from dual;

TO_CHAR(SYSDATE,'DD-
--------------------
29-MAR-2003 01:31:07


__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
Oracle LazyDBA home page