pure date and oure time data type in SQL 2008

Giganews Newsgroups
Subject: pure date and oure time data type in SQL 2008
Posted by:  iccsi (inun…@gmail.com)
Date: Wed, 12 Oct 2011

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

Replies