Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFinNC 2009 (Raleigh, North Carolina) with: Simon Free and Todd Sharp and Jason Dean and Andy Matthews
Ben Nadel at CFinNC 2009 (Raleigh, North Carolina) with: Simon Free@simonfree ) , Todd Sharp@cfsilence ) , Jason Dean@JasonPDean ) , and Andy Matthews@commadelimited )

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 »