asked
Datetime Insert Error
I am getting these errors when trying to insert datetime value into my table SET IDENTITY_INSERT table1 ON CREATE TABLE table1 ( id int PRIMARY KEY IDENTITY, submitted datetime NOT NULL) INSERT INTO table1 (id, submitted) Values (8, '2011-07-06 12:00:06') I get this error: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. If i try INSERT INTO table1 (id, submitted) Values (8, 2011-07-06 12:00:06) I get this error: Incorrect syntax near '12'.
You will need to put the date value in quotes ' like INSERT INTO table1 (id, submitted) Values (8, '2011-07-06 12:00:06') assuming the date string can be unambiguously converted to a date in your locale/regional settings
That's why I said make sure it can be a date :) try values(8, '6 July 2011 12:00:06')
