SQL Server 2005中如何比较两个日期找出时差，日期操作 [英] How to compare two dates to find time difference in SQL Server 2005, date manipulation

问题描述

我有两列:

job_start                         job_end
2011-11-02 12:20:37.247           2011-11-02 13:35:14.613

如何使用 T-SQL 查找作业开始和作业结束之间经过的原始时间量?

How would it be possible using T-SQL to find the raw amount of time that has passed between when the job started and when the job ended?

我试过了:

select    (job_end - job_start) from tableA

但最后是这样的:

1900-01-01 01:14:37.367

推荐答案

查看DateDiff() 函数.

-- Syntax
-- DATEDIFF ( datepart , startdate , enddate )

-- Example usage
SELECT DATEDIFF(DAY, GETDATE(), GETDATE() + 1) AS DayDiff
SELECT DATEDIFF(MINUTE, GETDATE(), GETDATE() + 1) AS MinuteDiff
SELECT DATEDIFF(SECOND, GETDATE(), GETDATE() + 1) AS SecondDiff
SELECT DATEDIFF(WEEK, GETDATE(), GETDATE() + 1) AS WeekDiff
SELECT DATEDIFF(HOUR, GETDATE(), GETDATE() + 1) AS HourDiff
...

你可以看到它的实际效果/在这里玩

You can see it in action / play with it here

这篇关于SQL Server 2005中如何比较两个日期找出时差，日期操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！