让我们首先创建一个表-mysql>createtableDemoTable1570
->(
->ArrivalTimedatetime
->);
使用插入命令在表中插入一些记录-mysql>insertintoDemoTable1570values('-10-155:10:00');
mysql>insertintoDemoTable1570values('-10-1523:00:00');
mysql>insertintoDemoTable1570values('-10-1523:10:00');
mysql>insertintoDemoTable1570values('-10-1516:10:00');
使用select语句显示表中的所有记录-mysql>select*fromDemoTable1570;
这将产生以下输出+---------------------+
|ArrivalTime|
+---------------------+
|-10-1505:10:00|
|-10-1523:00:00|
|-10-1523:10:00|
|-10-1516:10:00|
+---------------------+
4rowsinset(0.00sec)
当前日期如下-mysql>selectnow();
+---------------------+
|now()|
+---------------------+
|-10-1522:26:14|
+---------------------+
1rowinset(0.00sec)
以下是获取时差的查询-mysql>select*fromDemoTable1570
->whereArrivalTime>now()-interval5hour;
这将产生以下输出+---------------------+
|ArrivalTime|
+---------------------+
|-10-1523:00:00|
|-10-1523:10:00|
+---------------------+
2rowsinset(0.00sec)