sql server 2005 怎样让DateTime只存年月日或者用别的什么类型？(在线等)

CREATE TABLE #DateSample(

	ID int IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,

	date1 datetime NOT NULL,

	date2 char(8) NOT NULL,

	date3 int NOT NULL,

	date4 int NOT NULL

)

GO

INSERT INTO #DateSample

VALUES(

	CONVERT(char(8),GETDATE(),112),

	CONVERT(char(8),GETDATE(),112),

	DATEDIFF(day,0,GETDATE()),

	CAST(CONVERT(char(8),GETDATE(),112) AS int)

)

GO

SELECT *,

	dt1 = date1,

	dt2 = CAST(date2 AS datetime),

	dt3 = DATEADD(day,0,date3),

	dt4 = CAST(CAST(date4 AS char(8)) AS datetime)

FROM #DateSample

GO