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

Phil Morris

Member since Nov 21, 2011

Recent Blog Comments By Phil Morris

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

    Posted on Nov 21, 2011 at 4:28 AM

    I like the floor() one personally, but the one that sticks in my brain for some odd reason (mainly cos it just works) is this one: select convert(datetime,convert(varchar(10),getdate(),120),120) today You can also change the varchar(10) to the length in the ISO date format 120 to the portion y... read more »