Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Dee Sadler
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Dee Sadler@DeeSadler )

James Knowlton

Member since Dec 11, 2008

Recent Blog Comments By James Knowlton

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

    Posted on Jan 4, 2007 at 5:14 PM

    I also run into the date/time problem on SQL Server. I have solved the problem in several ways. When possible I simply create the table column with a check statement that prevents time from being added: create table test ( dateonly datetime null constraint ckc_dateonly check (DateOnly is null or... read more »