-
查询当日:
DATEDIFF(dd,时间字段,getdate()) = 0
-
查询昨日:
DATEDIFF(dd,时间字段,getdate()) = 1
-
查询明日:
DATEDIFF(dd,getdate(),时间字段) = -1
-
查询本周(默认从周日开始到周六):
DATEDIFF(week,字段,getdate()) = 0
-
查询本月:
DATEDIFF(month,字段,getdate()) = 0
-
查询本年:
DATEDIFF(year, GetDate(), 字段 ) = 0
-
格式化日期:
FORMAT(字段,'YYYY-MM-DD')
-
时间点比较:
time1 > time2 为负数; time1 < time2 为正数; 年: SELECT DATEDIFF([year],time1 , time2) 月: SELECT DATEDIFF([month], time1 , time2) 天: SELECT DATEDIFF([day], time1 , time2) 时: SELECT DATEDIFF([hour], time1 , time2) 秒: SELECT DATEDIFF([second], time1 , time2)
本文内容来自网络信息汇总