Archive for August, 2009

Why’s Ruby Guide Update

Monday, August 31st, 2009

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 :)

The Rounding Race – Rounding DateTimes to Dates at Midnight

Monday, August 31st, 2009

CalendarYesterday 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.

(more…)

One Second to Midnight – DateTimes in Sql Server 2005

Sunday, August 30th, 2009

One Second to MidnightToday 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).

(more…)