I wouldn't include this in the testcase. Same for datetimeoffset, I would only mention it in some comment like this.
The timestamp I would check againts its propper meaning in sqlsrv -> it will also test the correct behaviour that we do not do the conversion with it.