>If only this were available in 2000 and 2005:
>
>http://www.sqlteam.com/article/using-the-time-data-type-in-sql-server-2008
>http://blog.sqlauthority.com/2007/12/23/sql-server-2008-new-datatypes-date-and-time/
>
>
>sure would have saved me some trouble! :o)

How do you create time and date only portion of the dates? (SQL Server 2005)

Thanks in advance.