发布于 2011-10-17 20:32:27
1楼
DATE_AND_TIME格式数据,共8个字节,存储格式为BCD码,并不是十六进制
The data type Date_And_Time is stored in BCD format:
Byte Contents Range
0 Year 90-89 (from 1990 to 2089)
1 Month 01 ... 12
2 Day 1 ... 31
3 Hour 0 ... 23
4 Minute 0 ... 59
5 Second 0 ... 59
6 The two higher-
order places of ms 00 ... 99
7 (higher-
order place) The lowest-order
place of ms 0 ... 9
7 (lower-
order place) Day of week 1 ... 7 (1 = Sunday)
No discussion, no outcome.