Month: April 2008

VB.NET DateSpan Class

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  ...

Political Comments on March 25, 2008

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....

How to Get the Date of a DateTime in SQL Server

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!...