Date/Time format problem

[Andrew Grosset]

I'm trying to input a date and time into a SQL 2000 database.
The date is correctly updated but the time is always set to zeros.
How do I get the time value (1 sec before midnight) to be updated?

<cfset thisDate=CreateDateTime(year(Now()), month(Now()), Day(Now()), 23, 59, 59)>
<cfset paidDate=CreateODBCDateTime(thisDate)>

<cfquery datasource="*******">
UPDATE client1
SET paidDate = <cfqueryparam cfsqltype="cf_sql_date" value="#paidDate#">,
    sub_period = #sub_period#
    WHERE ID=#form.ID#
</cfquery>

thanks, Andrew.

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---