¡¾MySQLÊý¾ÝÀàÐÍ2Ö® ÈÕÆÚʱ¼äÀàÐÍ¡¿

MySQLÈÕÆÚʱ¼äÀàÐÍ´óÖ¿ÉÒÔ·Ö³É(5.0°æ±¾)£º
DATE:4×Ö½Ú 1000-01-01 ----9999-12-31
TIME:3×Ö½Ú -839:59:59 -----839:59:59
YEAR:1×Ö½Ú 1901-----2155
DATETIME:8×Ö½Ú 1000-01-01 00:00:00 -------- 9999-12-31 23:59:59
TIMESTAMP:4×Ö½Ú 19700101080001 -------2038Äêij¸öʱ¿Ì
 
ʹÓÃСÀý£º
 
1.DATE¡¢TIME¡¢DATETIMEµÄ¼òµ¥Ê¹ÓÃ
mysql>create table test(t1 date,t2 time,t3 datetime);
mysql>insert test values(now(),now(),now());
mysql> select * from test;
+------------+----------+---------------------+
| t1         | t2       | t3                  |
+------------+----------+---------------------+
| 2010-05-14 | 15:55:38 | 2010-05-14 15:55:38 |
+------------+----------+---------------------+
 
2.YEARµÄ·¶Î§Ó¦ÓÃ
mysql> create table test2(t year);
mysql> insert test2 values(02),(89);
mysql> select * from test2;
+------+
| t    |
+------+
| 2002 |
| 1989 |
+------+
 
ÔÚ²åÈëÄê·ÝÓöµ½2λÊýµÄʱºò£¬ÒòΪ´æÔÚÄê·ÝÖصþ£¬ÓÐÈçϹ涨£º00--69 ±íʾ 2000-2069
70-99 ±íʾ 1970-1999
 
 
 
3.TIMESTAMPµÄʹÓÃ
create table test3(value int,t1 timestamp,t2 timestamp);
insert test3 values(1,null,null);
mysql> select * from test3;
+-------+---------------------+---------------------+
| value | t1                  | t2                 &nb