Date and Time in SQLServer 2005

27 Apr 2006 6:55 PM

Helmut Woess

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?

Helmut

27 Apr 2006 7:07 PM

ML

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/

27 Apr 2006 7:30 PM

Gail Erickson [MS]

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/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

Show quote

"ML" <M*@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/