Problem with SQL Server smalldatetime insert query
insert, sql-server, sql-server-2000
Solution
Just use `:` in your time instead of `.`. Then it will insert fine.
Problem
I have the field: ``` APP_DATE (smalldatetime) ``` I'm doing this query: ``` INSERT INTO table (TYPE, CODE, APP_DATE, DATE) VALUES ('APP', '123', '02/10/2010 12.30', GETDATE()) ``` It fails: ``` Msg 296, Level 16, State 3, Line 1 Conversion from datatype char to smalldatetime generated a value not between the interval of valid values. Instruction has been interrupted. (0 row(s) affected) ``` What am I doing wrong? It appears to me as the correct format for the field.. Thank you for your time. EDIT: SQL Server 2000