select datediff(d, '2012-10-05' , '2012-11-21')
SELECT DATEDIFF(DAY, convert(datetime,'5.10.2012',104), convert(datetime,'21.11.2012',104)) as Difference
select datediff(mi, '2012-10-05 15:29:55.090' , '2012-11-21 15:30:09.153')
SELECT DATEDIFF(dd,'24 March 1964','24 March 2001')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)