Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-23 : 10:57:09
|
| Ali Batuk writes "I am getting the following error on a SQL 2000 server, and it drives me crazy.The error message [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. SQL statementINSERT INTO members (username, description, registerdate)VALUES ('username', 'test account', '11/21/2001')SQL executionConn.Execute(SqlStatement)I tried the same Sql statement within SQL server and it worked, but it doesn't work in my asp page. The date value for the "registerdate" field is doing this.Please someone help before I go crazy!!!" |
|
|
|
|
|
Inserting date into SQL 2000 Server