sqlserver中的datetime类型对应问题,数据库数据如下:
name time
5555 2000-03-30 10:07:10.010
66666 2000-03-20 10:07:10.100
Model类字段映射文件结果
| | | |
| Model类字段 | 映射文件 | 执行结果 |
| Time time; | <property name="time" column="time" type="time" /> OR <property name="time" column="time" /> | [name=5555 , time=10:07:10] [name=66666 , time=10:07:10] |
| java.utils.Date time | <property name="time" column="time" /> | [name=5555 , time=2000-03-30 10:07:10.01] [name=66666 , time=2000-03-20 10:07:10.1] |
| java.utils.Date time | <property name="time" column="time" type="date" /> | [name=5555 , time=2000-03-30] [name=66666 , time=2000-03-20] |
| java.sql.Date time | <property name="time" column="time" /> OR <property name="time" column="time" type="date" /> | [name=5555 , time=2000-03-30] [name=66666 , time=2000-03-20] |
| Timestamp time | <property name="time" column="time" type="timestamp" /> OR <property name="time" column="time" /> | [name=5555 , time=2000-03-30 10:07:10.01] [name=66666 , time=2000-03-20 10:07:10.1] |