asp date() to SQL Server - HTML Forums

moiseszaragoza · 09-02-2009, 02:43 PM

I am trying to insert into a datefield in the SQL Server
but i get this error

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][SQL Native Client][SQL Server]Operand type clash: text is incompatible with date

/admin/news.asp, line 96

the value of my date is 9/2/2009

afterburn · 09-08-2009, 09:18 AM

where is the server hosted? if it is not in US then the format wouldn't be like that.

JosephJames · 09-11-2009, 02:44 PM

I use 'YYYY/MM/DD' format. Please check this article. http://www.eggheadcafe.com/software/...ings-into.aspx

afterburn · 09-14-2009, 09:53 AM

Joseph,

The format you are using means the codepage and LCID of the script needs to be a specific format. Otherwise you are inserting text into the database which is 12bytes long vs 4 bytes for smalldatetime. 3 times the size and 12 times longer to search for data on it as a date is stored as a long under the hood in all RDBMs

JosephJames · 09-18-2009, 05:34 AM

Ok, So the best bet is to use parameters I think when dealing with strings and dates!