calculating difference between two time

Question

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.

Midhun T P · Answer

Hi You can get difference of two dates in days using below query SELECT DATEDIFF(daydeparturearrival) AS timespent from yourtable if you want difference in hours just use hour instead of day in above query. Same for minute second etc...

Krishna Rajput Singh · Answer

Hi Thanks for writing below links helpful for you...... http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=186156 https://msdn.microsoft.com/en-in/library/ms189794.aspx