CODEWITHSUNDEEP
sqlsql-server-2008
Shehab
Shehab

Reputation: 95

SQL Server select difference between two dates

enter image description here Dears,

I want to get time difference between two dates in DATESTAMP column between two types only "Open" & "Status Change". I wrote this query, but i got null and error message

declare @StartDate datetime, @EndDate datetime
set @StartDate = (Select Datestamp from ACTIVITYM1 where TYPE='Open')
set @EndDate = (Select Datestamp from ACTIVITYM1 where TYPE='Status Change')
select convert(varchar(5),DateDiff(s, @startDate, @EndDate)/3600)+':'+convert(varchar(5),DateDiff(s, @startDate, @EndDate)%3600/60)+':'+convert(varchar(5),(DateDiff(s, @startDate, @EndDate)%60)) as [hh:mm:ss]
from ACTIVITYM1

below is the error i got enter image description here

Upvotes: 0

Views: 235

Answers (1)

Alexander Vogt
Alexander Vogt

Reputation: 117

Look at the error message: "Subquery returned more than 1 value...". You need to select only one row, e.g.:

set @StartDate = (Select Datestamp from ACTIVITYM1 where TYPE='Open' AND THENUMBER = '001A1419')

or set an limit to your query...

Upvotes: 5

Related Questions