Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2014 (Bloomington, MN) with: Dave Ferguson and Simon Free and Tim Cunningham and Jason Dean
Ben Nadel at cf.Objective() 2014 (Bloomington, MN) with: Dave Ferguson@dfgrumpy ) , Simon Free@simonfree ) , Tim Cunningham@TimCunningham71 ) , and Jason Dean@JasonPDean )

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 »