Date and Time in SQLServer 2005

Hello,
i heard about Date and Time as new datatypes in SQL Server 2005. But they
are still not implemented. Will they come with one of the next servicepacks
or with SQL Server 20XX in some years (or never)?
Can i do something with user defined datatype?
HelmutUser-defined types are the only option at the moment.
An almost official explanation from MS goes along the lines of "we focus on
what we do best, and leave the rest to third party tools". :) But you didn't
hear that from me... ;)
ML
http://milambda.blogspot.com/|||You might take a look at the sample "Calendar-Aware Date/Time UDTs" that
ships with the AdventureWorks samples in SQL Server 2005. If you don't have
the samples installed, you can download them from here:
http://www.microsoft.com/downloads/...&displaylang=en
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"ML" <ML@.discussions.microsoft.com> wrote in message
news:FB5ACA56-B14D-4CDD-93BE-959B5C8BE173@.microsoft.com...
> User-defined types are the only option at the moment.
> An almost official explanation from MS goes along the lines of "we focus
> on
> what we do best, and leave the rest to third party tools". :) But you
> didn't
> hear that from me... ;)
>
> ML
> --
> http://milambda.blogspot.com/