'How to get TimeSpan from SafeDataReader?

I wanted to get the timespan value from my storedprocedure on mss, but I'm having a hard time how can I get it from SafeDataReader?

this is my property

public TimeSpan Total { get; set; }

this is on my fetch method where dr is SafeDataReader

Total = dr.GetDateTime("HOURSWORK");

and I'm having an error but I know that this is wrong I just don't how to work with timespan

Cannot implicitly convert type 'System.DateTime' to 'System.TimeSpan'

I'm expecting something like 09:30:21 from my SP where column is that HOURSWORK.

c++sharp

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source