摘要： declare @table table(tm datetime)insert into @table values('2013-05-07 07:55:00')insert into @table values('2013-05-07 07:57:00')insert into @table va... 阅读全文

摘要： --年、月、日、时、分、秒datediff(yy,date1,date2)datediff(m,date1,date2)datediff(d,date1,date2)datediff(hh,date1,date2)datediff(n,date1,date2)datediff(s,date1,dat... 阅读全文

摘要： selectdatename(hour,getdate())+':'+datename(minute,getdate())+':'+datename(second,getdate()) 阅读全文