Community Member Profile

Recent Blog Comments By Dan M.

• Getting Only the Date Part of a Date/Time Stamp in SQL Server

  Posted on Jun 3, 2008 at 3:26 PM

  I agree. That is the slickest solution. I actually just added it to my little toolbox of functions. CREATE FUNCTION fnShortDate(@date datetime) RETURNS datetime AS BEGIN declare @dateback datetime SELECT @dateback=DATEADD(DAY,DATEDIFF(DAY, 0, @date),0) read more »

• Getting Only the Date Part of a Date/Time Stamp in SQL Server

  Posted on Mar 24, 2008 at 4:50 PM

  Thank you thankyou thankyou. What a pain in the butt. I had to get the invoices sent between 2 specific dates and the hours were really slowing things down... expecially the conversion back and forth for the criteria. I actually change the structure of the view I was using to draw data fr... read more »