Hi,
How to get morethan 3minutes between two date fields
submit_date - dtm_AlarmStartTime are two fields date
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) as Difference
from HPD_Help_Desk where dateadd(s,submit_date+'19800','19700101') >CONVERT(date,sysdatetime())