I think timeformat(date_field_name), "hh:mm:ss") will help.
-----Original Message-----
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 8:31 AM
To: CF-Talk
Subject: oracle sysdate time
anyone know how to get the time part of an oracle date field to show up in a
result. I have a table where "date_entered" is the primary key and when I
query it in oracle developer I see the time (hh:mi:ss)part but not in CF.
createodbcdatetime() does not work
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
