Actually,
I just tested using <cfqueryparam cfsqltype="cf_sql_date"
value="#CreateODBCDate('01/jan/2007 23:02')#"> and the debug out showed the
time portion still being passed as well as the date.
>>> Haikal Saadh <[EMAIL PROTECTED]> 20/06/2007 10:24 am >>>
I don't think it's strange... a date is not a timestamp. If you want to
use a date you should use CF_SQL_DATE.
Scott Thornton wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
