pure date and oure time data type in SQL 2008

I heard that SQL server 2008 has pure date or pure time data type.
I tried to create a table, but I do not see date or time in the
dropdown.
I checked online help document it says

CREATE TABLE Table1 ( Column1 date )

If SQL Server 2008 can create pure date column using SQL then it
should appear on the dropdown.


Please let me know if I am wrong,

Your help is great appreciated,


iccsi

iccsi schreef op 12-10-2011 21:06:
> I heard that SQL server 2008 has pure date or pure time data type.
> I tried to create a table, but I do not see date or time in the
> dropdown.
> I checked online help document it says
>
> CREATE TABLE Table1 ( Column1 date )
>
> If SQL Server 2008 can create pure date column using SQL then it
> should appear on the dropdown.
>
>
> Please let me know if I am wrong,
>
> Your help is great appreciated,
>
>
> iccsi
Date appears in the dropdown as the 5th entry from the top in my
installation.
Time(7) appears in the dropdown as the 9th entry from the bottom.

(Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009
10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Enterprise
Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2) )

Best,
Henk