SQL Server 2014如何DATEDIFF()函数截取对应时间年月日

4.1 定义和用法: DATEDIFF()函数返回两个日期之间的时间

4.2 语法

      DATEDIFF(datepart,startdate,enddate)

      datepart值: year | quarter | month | week | day | hour | minute | second

      startdate:开始日期

      enddate:结束日期

     GetDate()获取系统当前时间

 4.3  DATEDIFF截取时间示例

        查询今天
        SELECT * FROM tablename where DATEDIFF(day,inputdate,GETDATE())=0

    查询昨天
        SELECT * FROM tablename where DATEDIFF(day,inputdate,GETDATE())=1

    查询本周
         SELECT * FROM tablename where datediff(week,inputdate,getdate())=0

    查询上周
         SELECT * FROM tablename where datediff(week,inputdate,getdate())=1

    查询本月
         SELECT * FROM tablename where DATEDIFF(month,inputdate,GETDATE())=0

    查询上月
         SELECT * FROM tablename where DATEDIFF(month,inputdate,GETDATE())=1