jamalogist
Member since Jan 6, 2009
- Profile: /members/2752-jamalogist.htm
- Comments: 1
Recent Blog Comments By jamalogist
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Jan 6, 2009 at 11:25 AM
And this is why I prefer Oracle. trunc() gives you back the date only, and keeps it in date format for date math like last_day(). Can't believe you have to jump through hoops this much in SQL Server.... read more »