NOW、CURRENT_TIMESTAMP和SYSDATE:都是返回系统的当前时间;
mysql> SELECT NOW(),CURRENT_TIMESTAMP(),SYSDATE();
+---------------------+---------------------+---------------------+
| NOW() | CURRENT_TIMESTAMP() | SYSDATE() |
+---------------------+---------------------+---------------------+
| 2014-01-12 15:24:24 | 2014-01-12 15:24:24 | 2014-01-12 15:24:24 |
+---------------------+---------------------+---------------------+
1 row in set (0.06 sec)
这三个函数返回的都是当前的时间,按上面的例子而言,好像功能是相同的;
mysql> SELECT NOW(),CURRENT_TIMESTAMP(),SYSDATE(),
-> SLEEP(2),
-> NOW(),CURRENT_TIMESTAMP(),SYSDATE();
+---------------------+---------------------+---------------------+----------+--
-------------------+---------------------+---------------------+
| NOW() | CURRENT_TIMESTAMP() | SYSDATE() | SLEEP(2) | N
OW() | CURRENT_TIMESTAMP() | SYSDATE() |
+---------------------+---------------------+---------------------+----------+--
-------------------+---------------------+---------------------+
| 2014-01-12 15:30:52 | 2014-01-12 15:30:52 | 2014-01-12 15:30:52 | 0 | 2
014-01-12 15:30:52 | 2014-01-12 15:30:52 | 2014-01-12 15:30:54 |
+---------------------+---------------------+---------------------+----------+--
-------------------+---------------------+---------------------+
1 row in set (2.00 sec)
加入SLEEP函数,让其等待2秒,这时发现SYSDATE()和NOW(),CURRENT_TIMESTAMP()返回的时间是不同的;
原因:
CURRENT_TIMESTAMP是NOW的同义词,即两者是相同的;
SYSDATE函数返回的是执行到当前函数的时间,而NOW返回的是执行SQL语句时的时间;
对于NOW函数,不管是在SLEEP()函数之前或之后执行,返回的都是执行这条SQL语句时的时间;