Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at cf.Objective() 2014 (Bloomington, MN) with: Elliott Sprehn

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 »