calculating difference between two time

Jul 23 2016 6:55 AM
i have two columns in my DB departure and arrival time where i get them by GETDATE() with data type of datetime I want to find the difference between them and store it in timespent  with data type nvchar(50) ,then call the value of timespent convert it into double so i can use it in calculation.
 in new to C# please help. 

Answers (2)