Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2010 (Minneapolis, MN) with: Jamie Krug and Simon Free
Ben Nadel at cf.Objective() 2010 (Minneapolis, MN) with: Jamie Krug@jamiekrug ) and Simon Free@simonfree )

bbn911

Member since Jul 16, 2009

Recent Blog Comments By bbn911

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

    Posted on Jul 16, 2009 at 5:08 PM

    here is another option - should be faster... ALTER FUNCTION [dbo].[GetDateOnly] ( @DateToFix DateTime ) RETURNS DateTime AS BEGIN DECLARE @dateMask bigint DECLARE @timeMask bigint SET @dateMask = 0xffffffffff000000 SET @timeMask = 0x0000000000ffffff Return CAST(CAST((CAST(@DateToFix as binary... read more »