|
|
Posted by Erland Sommarskog on 10/02/78 11:45
Larry Bertolini (bertolini.1@osu.edu) writes:
> For some reason, I recall having read that SQL Server 2005 would support
> a datatype that represented date, but not time. (This would be useful
> for storing things like birthday, where you usually don't care about the
> time of day). But I've got SQL Server 2005 installed, and there's no
> such datatype to be found.
>
> Is this something that might be released in a Service Pack, or is it
> just not going to happen?
I definitely hope it's going to happen, but it's not going to happen in
a service pack!
Your recollection is not incorrect. The first beta of SQL 2005 did have a
date data type (and a time data type). However, this was dropped and
that might be just as well. I bet you expect a date type to be compatible
with datetime, work just like datetime with dateadd() and the like.
Instead the date type was implemented in the CLR, and had completely
different syntax and operations, and was not very compatible with
datetime.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|