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

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 »