I’ve just updated Why’s Ruby Guide pdf to include Chapter 7’s images; go to the specific page with updates. Thanks to Andy Matuschak for pointing this out to me, and giving me a link to where the documents are still available on the internet 🙂
Monthly Archives: August 2009
The Rounding Race – Rounding DateTimes to Dates at Midnight
Yesterday I covered the implementation details of DateTime and SmallDateTime datatypes in SQL Server 2005. I approached the issue of testing dates to see if they fell on a particular date… but then stopped-short of some fairly useful (but arcane) stuff about rounding dates.
One Second to Midnight – DateTimes in Sql Server 2005
Today I am enthused to write about the DateTime and SmallDateTime datatypes in SQL Server 2005 (and possibly this also applies to 2008, although that has additional date and time types). I am driven to write this because I have seen a number of issues relating to their use in queries and one in particular that is a real annoyance to me – even if I have to admit that it is completely and utterly pedantic (most of the time).