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

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 »