sql server 计算两个时间段中间的 分钟数

Question

表如下
id         LandTime                      NowTime
1          2009-10-09 10:10:10.000       2009-10-10 11:11:11.000计算LandTime合NowTime之间的分钟数？

Answer 1

datediff(minute,times,getdate())

Answer 2

            DateTime LandTime = Convert.ToDateTime("2009-10-09 10:10:10.000");
            DateTime NowTime = Convert.ToDateTime("2009-10-10 11:11:11.000");
            long dtResult = (NowTime.Ticks - LandTime.Ticks) / (1000 * 10000)/60;