Community Member Profile
Phil Morris
Member since Nov 21, 2011
- Profile: /members/9272-Phil-Morris.htm
- URL: blackrosesolutions.co.uk
- Comments: 1
- Points: 12
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... read more »
