Chronicals of… a developer in Johannesburg

One of two ways:

1st in their group:
53 28/06 16:00 Durban 1E - 2F
57 02/07 16:00 Nelson Mandela Bay/Port Elizabeth W53 - W54
61 06/07 20:30 Cape Town W58 - W57
64 11/07 20:30 Johannesburg W61 - W62

2nd in their group:
55 29/06 16:00 Tshwane/Pretoria 1F - 2E
60 03/07 20:30 Johannesburg W55 - W56
62 07/07 20:30 Durban W59 - W60
64 11/07 20:30 Johannesburg W61 - W62

See http://www.fifa.com/worldcup/matches/kostage.html

With just over 4 weeks until my wedding, there is much to do. Blogging has been put at the back of that list.

I did figure out something interesting in SQL though. If you want to group a bunch of dates by day, but not by the second, but still want to return a datetime value just do this:

CONVERT(datetime,CONVERT(varchar, dateValue, 102))