DateTime now = DateTime.Now;
DateTime d1 = new DateTime(now.Year, now.Month, 1);
DateTime d2 = d1.AddMonths(1).AddDays(-1);
Select Convert(varchar(8),getdate(),8) --当前小时分钟:18:25:17
Select DateDiff(Minute,'2009-11-9 16:20:00','2009-11-9 16:30:00') --相差分钟:10
Select DateDiff(Minute,Convert(varchar(8),getdate(),8),'8:30') --小于0迟到
Select DateDiff(Minute,'18:00',Convert(varchar(8),getdate(),8)) --小于0早退