mysql 如何获取当前时间 前一小时的时间？

[骑着蜗牛追乌龟]

问题如题，大家帮忙啊！

mysql 如何获取当前时间 前一小时的时间？

[nicenight]

mysql> select now();            
+---------------------+
| now()               |
+---------------------+
| 2011-08-08 13:59:30 |
+---------------------+
1 row in set (0.00 sec)

mysql> select date_sub(now(), interval 1 hour);
+----------------------------------+
| date_sub(now(), interval 1 hour) |
+----------------------------------+
| 2011-08-08 12:59:31              |
+----------------------------------+
1 row in set (0.00 sec)

[nodream521]

1喽正解

[sforiz]

select DATE_ADD(Now(),INTERVAL -1 hour);
select DATE_ADD(CURRENT_TIME(),INTERVAL -1 hour);

[taiyangzhiya]

[Quote=引用 1 楼 nicenight 的回复:]

SQL code
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2011-08-08 13:59:30 |
+---------------------+
1 row in set (0.00 sec)

mysql> sele……
[/Quote]
正解+1

[rucypli]

where time < date_sub(NOW(),interval 60 minute);

[ACMAIN_CHM]

select now() - interval 1 hour;

[ACMAIN_CHM]

mysql> select now(),now() - interval 1 hour;
+---------------------+-------------------------+
| now()               | now() - interval 1 hour |
+---------------------+-------------------------+
| 2011-08-08 14:32:11 | 2011-08-08 13:32:11     |
+---------------------+-------------------------+
1 row in set (0.11 sec)

mysql>

[小姜哥]

这东西我怎么给忘了，回头用的时候还得查。