Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.


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 »