Dan M.
Member since Dec 11, 2008
- Profile: /members/1361-dan-m.htm
- URL: http://morrisdev.com
- Comments: 2
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) return @dateback END GO so now I ca... 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 from in my... read more »