Just a bit of basics about DateTime datatype in SQL Server, it has two different date/time columns. They are DATETIME and SMALLDATETIME and the difference between these two SQL Server date/time data types. SQL Server has a number of default formats it expects raw date and time data to be in when inserting dates into a DATETIME, or SMALLDATETIME columns. If you attempt to insert a date that does not match one of the default date formats, then SQL Server will reject the date/time value. If your raw...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2008/08/26/working-with-datetime-data-types-in-sql-server-guidelines-and-explanations.aspx