22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT GetDate() Now, DATEADD(day, -1, GetDate()) PrevDay
Now PrevDay
------------------------------------------------------ ------------------------------------------------------
2014-07-30 10:35:35.857 2014-07-29 10:35:35.857
where updatetime >= DATEADD(day, -1, GetDate())
select datediff(day,'2014-01-01 00:00:00','2014-01-02 00:00:00') --天
select datediff(hour,'2014-01-01 00:00:00','2014-01-02 00:00:00') --时
select datediff(second,'2014-01-01 00:00:00','2014-01-02 00:00:00') --分钟
select datediff(minute ,'2014-01-01 00:00:00','2014-01-02 00:00:00') --秒