SQL Server Performance

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

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 26, 2008.

  1. Anonymous New Member

    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">

Share This Page