如何从两个日期获得3个数据 [英] How to get morethan 3 data from two dates

问题描述

如何在两个日期字段之间获得超过3分钟的时间？

Hi,

How to get more than 3 minutes between two date fields?

select Incident_Number, dateadd(s,submit_date+'19800','19700101') as 'submit_date', dateadd(s,dtm_AlarmStartTime+'19800','19700101') as 'dtm_AlarmStartTime',
(submit_date-dtm_AlarmStartTime)/60 from HPD_Help_Desk where dateadd(s,submit_date+'19800','19700101') > CONVERT(date, SYSDATETIME())

推荐答案

尝试DATEDIFF：

Try DATEDIFF:

SELECT Incident_Number, 
       dateadd(s, submit_date + '19800' , '19700101') as 'submit_date', 
       dateadd(s, dtm_AlarmStartTime + '19800','19700101') as 'dtm_AlarmStartTime',
       (submit_date - dtm_AlarmStartTime) / 60
FROM HPD_Help_Desk 
WHERE DATEDIFF(mi, submit_date, CONVERT(date, GETDATE()) > 3

这篇关于如何从两个日期获得3个数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！