Of course on Oracle the easiest way to insert the current time and date is to insert SYSDATE (if the CF server and the Oracle server agree on the current time, anyway).
mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/8/18 Stephen Weyrick <sweyr...@gmail.com>: > >>Is the column a date or a varchar - because you're using a varchar cfsqltype. >> >>I usually use the Oracle to_date() function to insert a date/time. >> >>mxAjax / CFAjax docs and other useful articles: >>http://www.bifrost.com.au/blog/ >>> > > I use MS SQL Server, but I think you could use something like this. > <cfqueryparam value="#now()#" CFSQLType="cf_sql_timestamp" /> > > If this doesn't work, try this... > <cfqueryparam value="#CreateODBCTime(now())#" CFSQLType="cf_sql_timestamp" /> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:325524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4