• This was a good question.

    However, remember that while the datetime2 datatype refernced in the answer will only return 3 rows, this was only added with SQL2008 and later versions (along with the DATE, TIME and DATETIMEOFFSET date types)

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”