I was asked by a client about the new Time datatype in SQL 2008. They wanted to store the duration of some work so they could use the nice date time functions to get the hours, minutes, seconds etc. However you can't use the Time date type for that, because it can only hold time up to midnight after...