SQL Server 2008 - New Data Types
SQL Server 2008 introduces new data types. Here you will find some of them:
The following images illustrate how the data is represented when using some of these data type.
There are some differences you should know when comparing data stored in different datetime data types.
For example, two variables storing the same date, one of the variables has a Datetime data type and the other one has a Date data type. When compared they are the same only if the time part is not specified (or filled up with zeros) at the moment the datetime data type variable is inputted/updated. Please see the images below for illustration.
Also, see what happens when you use the operand plus with a variable using the new Date type.
In this case use the DATEADD Function mentioned above.
.Send mail to
questions or comments about this web site.