Mega Code Archive

 

Categories / MSSQL Tutorial / Data Convert Functions

 

Select CAST(CAST(2002-09-30 AS datetime) - CAST(2001-12-01 AS datetime) AS int)

2> 3> select CAST(CAST('2002-09-30' AS datetime) - CAST('2001-12-01' AS datetime) AS int) 4> GO -----------         303 (1 rows affected) 1>