Jakob Flygare
Member since Nov 26, 2010
- Profile: /members/7360-jakob-flygare.htm
- Comments: 1
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 WHE... read more »