i have join view table where 1 table contain begin date amnd end date. i want calculate both of them as duratiowith format dd:hh:mm (2d:3h:34m)
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_i