Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at BFusion / BFLEX 2009 (Bloomington, Indiana) with: Peter Farrell and Matt Woodward and Kurt Wiersma
Ben Nadel at BFusion / BFLEX 2009 (Bloomington, Indiana) with: Peter Farrell , Matt Woodward@mpwoodward ) , and Kurt Wiersma

T. Phaneuf

Member since Dec 11, 2008

Recent Blog Comments By T. Phaneuf

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

    Posted on Feb 6, 2008 at 11:34 PM

    To strip time off of datetime values to store only the day, I usually just use this approach declare @DateValue datetime set @DateTest = getutcdate() select convert(datetime, convert(int, @DateTest)) - or - convert(datetime, convert(int, <DateColumn>)) To store only the time, it is a little... read more »