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

Jakob Flygare

Member since Nov 26, 2010

Recent Blog Comments By Jakob Flygare

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

    Posted on Nov 26, 2010 at 4:02 AM

    This is not the easiest syntax. See below where the two expressions accomplsih the same thing; ie. to get the item where the depublicationdate is seven day after the current date. The second expression is much easier to read: SELECT memorialcollectionid FROM dbo.tbl_MemorialCollection WHERE ... read more »