You can not use TO_DATE to return and display HH:MI:SS...TO_DATE
Is to convert a string into a DATE format. TO_CHAR is the one you use to
convert a DATE into
A desired format. Your 2nd SQL is doing that.

Regards
Rajesh Puneyani
Database Administrator
ADP EBS-IT
973 560 2647


-----Original Message-----
From: Sami Seerangan [mailto:[Email Address Removed]
Sent: Saturday, March 29, 2003 8:26 AM
To: LazyDBA.com Discussion
Subject: Date Format using to_date


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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page