select datediff(minute, '2011-01-02 12:00:00', '2011-01-02 12:30:00') as minutes
SELECT DATEDIFF(minute, '2005-12-31 23:59:59.9999999', '2006-01-01 00:00:00.0000000');
SELECT DATEDIFF(minute, '2005-12-31T23:59:59.999', '2006-01-01T00:00:00.999');
SELECT DATEDIFF(minute, '2005-12-31 23:59:59.999', '2006-01-01 00:00:00.000');
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)