You have to specify it in the query itself . . . select to_char(date_field,
'dd-mon-yyyy hh24:mi:ss') . . . then once you have it in CF you can do what
you want with it.
Dan
-----Original Message-----
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 5: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
