TIMESTAMP 本身就是存放的秒数1281507239 ,只不是显示形式是 2010-08-10 12:14:18。你可以在查询的时候用+0处理。 select col+0 from table1
因为目前mysql不支持在default 后面+函数的形式 所以不能将时间通过unix_timestamp(now())转换所以目前只能通过这样的形式 alter table tb add ts timestamp然后你要调用ts的时候使用 select unix_timestamp(ts) as ts from tb
mysql> alter table t1 add ttime timestamp;
Query OK, 0 rows affected (0.44 sec)
Records: 0 Duplicates: 0 Warnings: 0mysql> desc t1;
+-------+-----------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-----------+------+-----+-------------------+-----------------------------+
| a | int(11) | YES | | NULL | |
| b | char(10) | YES | | NULL | |
| ttime | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+-------+-----------+------+-----+-------------------+-----------------------------+
3 rows in set (0.00 sec)mysql> insert into t1(a,b) values (1,'a');
Query OK, 1 row affected (0.05 sec)mysql> select * from t1;
+------+------+---------------------+
| a | b | ttime |
+------+------+---------------------+
| 1 | a | 2010-08-10 12:14:18 |
+------+------+---------------------+
1 row in set (0.00 sec)mysql>
每个表只能有一个 timestamp字段,此字段在修改记录的时候会自动更改为当前系统时间。
alter table tb add ts timestamp然后你要调用ts的时候使用
select unix_timestamp(ts) as ts from tb