Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at RIA Unleashed (Nov. 2010) with: Bob Silverberg and Carol Loffelmann and Vicky Ryder and Simon Free
Ben Nadel at RIA Unleashed (Nov. 2010) with: Bob Silverberg@elegant_chaos ) , Carol Loffelmann ( @Mommy_md ) , Vicky Ryder@fuzie ) , and Simon Free@simonfree )

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 »