I just put it to the test on my own application with datetime field in the
database. #CreateODBCDate(Now())#
seems to work just fine.
Marianne Daye
-----Original Message-----
From: Eric Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 11:50 AM
To: CF-Talk
Subject: SQL Date Error --Help Needed
brain dead.
I am attempting to insert a date into a datetime field in SQL. It is the
correct ODBCdateformat...it is choking on the zeroed-out time stamp as only
a date is used in the field. What am I forgetting to get it to insert
properly? Change database datatype or some code?
Thanks.
Eric
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
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.mail-archive.com/[email protected]/
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.
