> Will the following create a value with or without a 'time' portion?
>
> <cfqueryparam cfsqltype="cf_sql_date" value="#Now()#">
Find out for yourself:
SELECT <cfqueryparam cfsqltype="cf_sql_date" value="#Now()#">
FROM table
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

