Oracle is probably just returning the date part of the value. Try... select to_char(date1,'HH:MI:SS') from yourTable
-----Original Message----- From: Mak Wing Lok [mailto:[EMAIL PROTECTED] Sent: None To: CF-Talk Subject: Timeformat incorrect I'm using oracle and when I try to disply time using timeformat (#timeformat(date1,"HH:mm:ss")#) from one of the date field, it returns 0:00:00, why was that? Any advise? --------------------------------------------------------------------------- "Pharmaniaga Berhad, your integrated healthcare provider" www.pharmaniaga.com "Pharmaniaga Solutions... placing technology in the heart of your business and information in the palm of your hands" The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential or privileged material. If you received this in error, please contact the sender and delete the material from any computer. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. --------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
