Hi, I had a bit of an unexpected problem whilst using the above today.
Problem is my time looks like '01/jan/2007 23:02' but I want to only use the date portion. So in a query I use: <cfquery datasource="#dsn#"> select * from sb_hospital where sb_accom_start_date > #CreateODBCDate('01/jan/2007 23:02')# </cfquery> which when runs, the date looks like '01/jan/2007' to the query. However <cfquery datasource="#dsn#"> select * from sb_hospital where sb_accom_start_date > <cfqueryparam cfsqltype="cf_sql_timestamp" value="#CreateODBCDate('01/jan/2007 23:02')#"> </cfquery> passes the full date with the time on it. Seems a bit strange to me. Not what I was expecting at all. CF MX 6.1. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---