If you didn't set the time in the date field, i.e., if it was user entered as 12/23/2002, then no time is available and doing a timeformat results in what you've seen. SYSDATE and a couple other Oracle functions (which I can't think of) to store full timestamps in a date column, whether you want them to or not. But if you don't explicitly insert a date AND time into a date field, it won't give back a meaningful time.
Or at least that's been my experience. -lincoln -----Original Message----- From: Mak Wing Lok [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 1:42 PM 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