22,300
社区成员




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