mysql 时间的插入和查找

lcathm

于 2014-10-23 16:40:51 发布

阅读量534

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/lcathm/article/details/40400085

mysql 专栏收录该内容

65 篇文章

订阅专栏

CREATE TABLE `time` (
`id1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`id2` datetime DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8

insert into time values('2014-10-20 16:16:24','2014-10-23 16:17:01');

mysql> select * from time;
+---------------------+---------------------+
| id1 | id2 |
+---------------------+---------------------+
| 2014-10-20 16:16:24 | 2014-10-23 16:17:01 |
| 2014-10-26 16:16:24 | 2014-10-26 16:17:01 |
+---------------------+---------------------+

mysql> select * from time where id1>now();
+---------------------+---------------------+
| id1 | id2 |
+---------------------+---------------------+
| 2014-10-26 16:16:24 | 2014-10-26 16:17:01 |
+---------------------+---------------------+