Hello,
Look at SqlDataReader.GetTimeSpan(Int32) Method. Then use .ToString("") or use the following or modify to suit
your needs.
Imports System
Imports System.Globalization
Namespace ExtensionsLibrary
Public Module DateTimeExtensions
''' <summary>
''' Convert TimeSpan into DateTime
''' </summary>
''' <param name="sender"></param>
''' <returns></returns>
''' <remarks>
''' Intended to be used when the date part does not matter
''' </remarks>
<System.Runtime.CompilerServices.Extension> _
Public Function ToDateTime(ByVal sender As TimeSpan) As DateTime
Return DateTime.ParseExact(sender.Formatted("hh:mm"), "H:mm", Nothing, DateTimeStyles.None)
End Function
''' <summary>
''' Format a TimeSpan with AM PM
''' </summary>
''' <param name="sender">TimeSpan to format</param>
''' <param name="format">Optional format</param>
''' <returns></returns>
<System.Runtime.CompilerServices.Extension> _
Public Function Formatted(ByVal sender As TimeSpan, Optional ByVal format As String = "hh:mm tt") As String
Return DateTime.Today.Add(sender).ToString(format)
End Function
End Module
End Namespace
Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via
my MSDN profile but will not answer coding question on either.
NuGet BaseConnectionLibrary for database connections.
My GitHub code samples
GitHub page
