Working with DateTime data types in SQL Server, guidelines and explanations!

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...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2008/08/26/working-with-datetime-data-types-in-sql-server-guidelines-and-explanations.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=4802" width="1" height="1">