You're telling CF to only insert the date (cf_sql_date). Assuming that your database column is setup to hold a timestamp (e.g. a data type of datetime, timestamp or similar), try the following:
<cfqueryparam cfsqltype="cf_sql_timestamp" value="#createODBCDateTime(getDate.date_field)#" /> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322379 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
