select datediff(d, '2012-10-05' , '2012-11-21')
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')
SELECT DATEDIFF(DAY, convert(datetime,'5.10.2012',104), convert(datetime,'21.11.2012',104)) as Difference
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)