Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at RIA Unleashed (Nov. 2009) with: Richard Bark
Ben Nadel at RIA Unleashed (Nov. 2009) with: Richard Bark

Antoine

Member since Dec 11, 2008

Recent Blog Comments By Antoine

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

    Posted on Dec 4, 2006 at 6:34 AM

    The UDF contains a small error. I couldn't create it. I had to replace the '-1' with just a '-'. And then I discovered it always results in a datetime with the time set to '01:00:00' So it should be: CREATE FUNCTION DateOnly(@date) RETURNS datetime WITH SCHEMABINDING as return DATEADD(ms, - DATEP... read more »