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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
