Chuck
Member since Dec 11, 2008
- Profile: /members/1811-chuck.htm
- Comments: 1
Recent Blog Comments By Chuck
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Feb 14, 2007 at 4:12 PM
Hey guys, Just thought I would post about this. I got around this problem very easily, this is the route for a non-programmer. declare @mydate datetime SET @mydate = (Getdate()) declare @mymonth varchar(2) set @mymonth = month(@mydate) declare @myday varchar(2) set @myday = day(@mydate) declare @m... read more »