convert sql server time and date type to .net TimeSpan and DateTime type.