Tired of writing code to find the years and months between two dates?
”’ <summary>
”’ Provides an easy way to get the number if years and months bewteen two dates.
”’ </summary>
”’ <remarks></remarks>
Public Class DateSpan
Dim _Years As Integer
Dim _Months As Integer
Public Sub New(ByVal StartDate As Date, ByVal EndDate As Date)
Dim intTotalMonths As Integer = DateDiff(DateInterval.Month, StartDate, EndDate)
_Years = intTotalMonths \ 12
_Months = intTotalMonths – (_Years * 12)
End Sub
Public ReadOnly Property Years() As Integer
Get
Return _Years
End Get
End Property
Public ReadOnly Property Months() As Integer
Get
Return _Months
End Get
End Property
End Class
Clinton
Admits that she ‘Misspoke’ about her trip to Bosnia. Either you intentionally embellished (lied?) about the trip, you forgot what happened, or you believe something happened and it didn’t. In any of those cases it’s not something I would expect in my future President.
Pretty simple really. Try this SQL:
SELECT CONVERT(nvarchar(20), GetDate(), 101);
or
SELECT CONVERT(nvarchar(20), CAST(‘2008-04-04 16:07:07.920′ AS DateTime), 101);
If you need to use it in a comparison you can easily do something like
WHERE CONVERT(nvarchar(20), MyDateColumn, 101) BETWEEN @DateFrom AND @DateTo
Enjoy!