Mysql创建语句中的数据类型包括时间类型,有一下几类:
| DATE | TIME[(fsp
)] | TIMESTAMP[(fsp
)] | DATETIME[(fsp
)] | YEAR
这几个类型中,特别值得注意的是DATE,DATETIME,TIMESTAMP有什么区别?
DATE
mysql> select get_format(date,'ISO'); +------------------------+ | get_format(date,'ISO') | +------------------------+ | %Y-%m-%d | +------------------------+ 1 row in set (0.00 sec)
DATETIME
mysql> select get_format(datetime,'ISO'); +----------------------------+ | get_format(datetime,'ISO') | +----------------------------+ | %Y-%m-%d %H:%i:%s | +----------------------------+ 1 row in set (0.00 sec)
TIMESTAMP
mysql> select get_format(timestamp,'ISO'); +-----------------------------+ | get_format(timestamp,'ISO') | +-----------------------------+ | %Y-%m-%d %H:%i:%s | +-----------------------------+ 1 row in set (0.00 sec)
TIME
mysql> select get_format(time,'ISO'); +------------------------+ | get_format(time,'ISO') | +------------------------+ | %H:%i:%s | +------------------------+ 1 row in set (0.00 sec)
YEAR
mysql>