MySQL日期数据类型、MySQL时间类型使用总结.docx

MySQL £ oMySQL e?? u(y?Y adD ? 0 MySQL e±?? adD 旌 1 o? Xu? a
MySQL e? udQ £ o e?? u?? @? 0 ? u?? '? 0 ????? 0 e?? u?? § 士e??? £
e? udQ i '? '0 ???? e?? u?? e? e?? u?? §
datetime 8 bytes YYYY-MM-DD HH:MM:SS 1000-01-01 00:00:00 ~ 9999-12-31
23:59:59
timestamp 4 bytes YYYY-MM-DD HH:MM:SS 1970-01-01 00:00:01 ~ 2038
date 3 bytes YYYY-MM-DD 1000-01-01 ~ 9999-12-31
year 1 bytes YYYY 1901 ~ 2155
? u MySQL ?D '?'•士 e±£ ????? e??? p? 士？？ £ ?o ugfoX? ? u????卩?0? eeX??o 卩？ e?Y adD? £ 2?1y 诃 |iX?e???
datetime ?1 e? timestamp £ ?? e? U acD p? ???? £ ?a a??? e? ue±?? adD ? *Qd? p? £ odatetime
诃 e?? u?? §±e? ' £ ?timestamp ? u?? '? '0 ???? ±e??D? £ ??? e? datetime 诃 o? °? £
aia £ ?timestamp adD i ?xdD?1 cD?? ?D? £ o?? e?? e??? £ ?? u insert, update e?Y e±£ ?timestamp
Q? ax?? _ O 卩士 ° e±?? £ CURRENT_TIMESTAMP £ ? ?3?/? UD?? £ ? ° X?? ? ± ? o??? e £ ???2? e¥ 1 u? u
£ ?MySQL ? a??? e¥ ' a? £
o? °? e???? £ ?? o??? ooue o? datetime e?? uacD ? £
MySQL e?? acD £ o e±???? e?? 0 ? u?? ? '0 ????? 0 e±?? ?? §? £
e士?？ acD i '? '0 ???? e±???? e? e士?？ ?? §
time 3 bytes HH:MM:SS -838:59:59 ~ 838:59:59
time e±?? ?? §? oe cD?a? ' ' ?o?(? §£ ? ? 士 e time ? eo? e?o? p£ ? oDp???1?? £ o o£?? ' ?0MySQL
e?2 a2??a pa?ae??a a??uX?a??? e?? ue±??? a??2??a? uee??p??£
select timediff('2000:01:31 23:59:59', '2000:01:01 00:00:00'); -- 743:59:59
select timediff('2000:01:01 00:00:00', '2000:01:31 23:59:59'); -- -743:59:59
select timediff('23:59:59', '12:00:00'); -- 11:59:59
X 0 aa £ ?timediff p? a???2? e??? ue? datetime/timestamp, time acD i p
£ ?2 0 ? o?a a???2? e aOD O? a?? £ ? ' £ odatetime/timestamp o i datetime/timestamp ±e??
£ ?time o itime ? a士e?? £
?? e? MySQL ?D 卩？ e?? ue±?? aQ 士e? -a?? £ ?诃 o?o? p? e? £ ???? ° £ '008-08-08
£ ??aD? e?? ue±?? acD ??? u? §3? p????? ±e £ ?2?? §?o a??? 0 ? 0 ??? £ c2?? cD2 ueo a?? p?o _y? £ ??MySQL £ oMySQL e? u$?Y acD ? 0 MySQL e±?? acD el o? Xu? a -eec? ouMySQL ? ° o? e? ° ±?? £
o?? 0 MySQL ?? p? p 士 ° e? ue±?? o 飞
?? p? p 士 ° e?? u+ e士?