No Access will freak out on that. it doesn't like the {ts in the inserted
data, gotta use DATEFORMAT(NOW()) with optional formatting for the users
benefit.
Fred
----- Original Message -----
From: "paul smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 29, 2000 1:30 PM
Subject: RE: RE: Unable To insert Proper Date
> At 02:03 PM 4/29/00 -0400, you wrote:
> >The following should work for both Access and SQL Server.
> >
> >Since Now() is already in ODBC format, inserting it is dead simple:
> >
> ><CFQUERY NAME="qryInsertDateTime" DATASOURCE="some_dsn">
> > INSERT INTO some_table (column_name)
> > VALUES (#Now()#)
> ></CFQUERY>
>
> Doesn't INSERT here for SQL Server 7 sp1, NT4sp6a
>
> I need to use VALUES (#CreateODBCDateTime(Now())#)
>
> best, paul
>
> PS> My recollection is my above is needed for Access, too.
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
