Loading

calculating difference between two time

simon macharia

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp10y ago
Accepted answer
Hi,
You can get difference of two dates in days using below query
SELECT DATEDIFF(day,departure,arrival) 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 Singh10y ago
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