让我们首先创建一个表-
mysql> create table DemoTable855(DueDate timestamp);
使用插入命令在表中插入一些记录-
mysql> insert into DemoTable855 values('2019-08-07'); mysql> insert into DemoTable855 values('0000-00-00'); mysql> insert into DemoTable855 values('2019-07-06'); mysql> insert into DemoTable855 values('2016-04-10');
使用select语句显示表中的所有记录-
mysql> select *from DemoTable855;
这将产生以下输出-
+----------------------+ | DueDate | +----------------------+ | 2019-08-07 00 −00 −00| | 0000-00-00 00 −00 −00| | 2019-07-06 00 −00 −00| | 2016-04-10 00 −00 −00| +----------------------+ 4 rows in set (0.00 sec)
以下是检查MySQL中是否设置了时间戳的查询-
mysql> select *from DemoTable855 where DueDate > 0;
这将产生以下输出-
+----------------------+ | DueDate | +----------------------+ | 2019-08-07 00 −00 −00| | 2019-07-06 00 −00 −00| | 2016-04-10 00 −00 −00| +----------------------+ 3 rows in set (0.03 sec)