页次: 1
timestamp 表示一个时间截 可以百度下
使用方法和 datetime 很类似,
使用方法可以参考
就是范围不同
示例
mysql> create table tb_timestamp (ts timestamp); Query OK, 0 rows affected (0.26 sec) mysql> insert into tb_timestamp values ("20000102111111") , ("2000-01-02 11:11:11" ), (now()); Query OK, 3 rows affected (0.06 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql> select * from tb_timestamp; +---------------------+ | ts | +---------------------+ | 2000-01-02 11:11:11 | | 2000-01-02 11:11:11 | | 2014-11-29 10:49:15 | +---------------------+ 3 rows in set (0.00 sec)
ipbbs.net
离线
页次: 1