Calculate Time difference between start DateTime and End DateTime in SQL Server

Hi Ruben12345,

Refer below SQL query

SQL

DECLARE @TABLEA AS TABLE (ID INT ,shipment_no INT,vehicle_name VARCHAR(50), member_name VARCHAR(50),begin_date_time DATETIME,create_date DATETIME,member_id INT,partner_id INT,vehicle_id INT,end_date_time DATETIME,active INT)
INSERT INTO @TABLEA VALUES(1,12233,'B1278HU','Unilever',' 2017-05-10 13:09:00','2017-05-09',3344552,4555433,1442344,'2017-05-12 12:00:00',0)
INSERT INTO @TABLEA VALUES(13,122433,'B12sx78HU','Unilexver',' 2017-05-29 13:09:00','2017-05-09',3344552,4555433,1442344,GETDATE(),0)

SELECT *,CONVERT(VARCHAR(5),DateDiff(dd, begin_date_time, end_date_time)) + ' Days '
	   + CONVERT(VARCHAR(5),DateDiff(hh, begin_date_time, end_date_time) % 24) + ' hours '
	   + CONVERT(VARCHAR(5),DateDiff(mi, begin_date_time, end_date_time) % 60) + ' minutes '
	   + CONVERT(VARCHAR(5),(DATEDIFF(S, begin_date_time, end_date_time)%60))+' seconds' As TotalDiff
FROM @TABLEA

Output

Ruben12345 says:

SELECT sa.id, sa.shipment_no, v.vehicle_name, m.member_name, sa.begin_date_time, sa.create_date, sa.member_id, sa.partner_id, sa.vehicle_id, sa.end_date_time, sa.active
FROM dbo.shipment_assignment AS sa INNER JOIN
 dbo.vehicles AS v ON v.vehicle_id = sa.vehicle_id INNER JOIN
 dbo.members AS m ON sa.partner_id = m.member_id

 replace above code with below

SELECT sa.id
	  ,sa.shipment_no
	  ,v.vehicle_name
	  ,m.member_name
	  ,sa.begin_date_time
	  ,sa.create_date
	  ,sa.member_id
	  ,sa.partner_id
	  ,sa.vehicle_id
	  ,sa.end_date_time
	  ,sa.active
	  ,  CONVERT(VARCHAR(5),DateDiff(dd, sa.begin_date_time, sa.end_date_time)) + ' Days '
	   + CONVERT(VARCHAR(5),DateDiff(hh, sa.begin_date_time, sa.end_date_time) % 24) + ' hours '
	   + CONVERT(VARCHAR(5),DateDiff(mi, sa.begin_date_time, sa.end_date_time) % 60) + ' minutes '
	   + CONVERT(VARCHAR(5),(DATEDIFF(S, sa.begin_date_time, sa.end_date_time)%60))+' seconds' As TotalDiff
FROM dbo.shipment_assignment AS sa INNER JOIN
dbo.vehicles AS v ON v.vehicle_id = sa.vehicle_id INNER JOIN
dbo.members AS m ON sa.partner_id = m.member_id