下面是结果集：
|
数据类型 |
输出 |
|---|---|
|
time |
12:35:29. 1234567 |
|
date |
2007-05-08 |
|
smalldatetime |
2007-05-08 12:35:00 |
|
datetime |
2007-05-08 12:35:29.123 |
|
datetime2 |
2007-05-08 12:35:29. 1234567 |
|
datetimeoffset |
2007-05-08 12:35:29.1234567 +12:15 |
原文：http://www.cnblogs.com/feb9903/p/4198837.html