Kevin, cool link- though I see that MS SQL2008 delivers a proper time field. ;-)
I have a new community presentation...what's new in sql '08....there are 2 features in particular that get oooos and aaaahhs...one is the new group by extensions, and the other is the ability to have separate date and time columns.