date,datetime,timestamp 的区别
date 表示年月日,如YY-MM-DD
datetime 表示年月日和时间信息,如YY-MM-DD HH:MM:SS
timestamp 和datetime表示的信息相同,但时间范围不同
时间范围
date -- > '1000-01-01' to '9999-12-31'.
datetime --> '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.
timestamp -- > '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC
参考:http://tremendousturtle.iteye.com/blog/671648
http://www.blogjava.net/fanyingjie/archive/2010/04/24/319239.html?opt=admin
http://database.51cto.com/art/200905/124240.htm
http://lhdeyx.blog.163.com/blog/static/318196972011230113645715/
转自百度空间
原文网址:http://hi.baidu.com/zml525/item/997a86246cd408150975086e