Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AAAV
Posting Yak Master
152 Posts |
 Posted - 2010-03-04 : 20:58:12
|
| What is the difference between the date time data types in sql server 2005 and sql server 2008.Thanks |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-03-04 : 21:15:53
|
| Are you talking Date and Time data types or *the* datetime data type? The datetime data type is the same in both versions. Represents dates from Jan 1, 1753 to Dec 31, 9999 with time accurracy of 3.33 miliseconds (if memory serves).There are some new date and time data types in 2008. I imagine these are what you mean.See Brad McGehee's article on all the new data types:http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-the-new-data-types/ |
 |
|
|
AAAV
Posting Yak Master
152 Posts |
Posted - 2010-03-04 : 21:24:04
|
| I am talking about the datetime and smalldatetime.Are they deprecated in sql server 2008? |
|
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-03-04 : 21:34:38
|
| No, they are not deprecated.http://msdn.microsoft.com/en-us/library/ms187752.aspx |
|
|
|
|
|
|
Date Types