Shulou(Shulou.com)06/01 Report--

This article will explain in detail the method of obtaining the current time in mysql for everyone. Xiaobian thinks it is quite practical, so share it with you for reference. I hope you can gain something after reading this article.

mysql method to get the current time: You can get the current time by executing the [select now();] statement. It can also be obtained by executing the [select current_timestamp, current_timestamp();] statement.

Get the current date + time (date + time) function: now()

mysql> select now();+---------------------+| now() |+---------------------+| 2008-08-08 22:20:46 |+---------------------+

Get the current date + time (date + time) function: sysdate()

sysdate() date-time function is similar to now() except that now() gets the value at the start of execution, sysdate() gets the value dynamically as the function executes. See the following example to understand:

mysql> select now(), sleep(3), now();+---------------------+----------+---------------------+| now() | sleep(3) | now() |+---------------------+----------+---------------------+| 2008-08-08 22:28:21 | 0 | 2008-08-08 22:28:21 |+---------------------+----------+---------------------+

MySQL gets current timestamp function: current_timestamp, current_timestamp()

mysql> select current_timestamp, current_timestamp();+---------------------+---------------------+| current_timestamp | current_timestamp() |+---------------------+---------------------+| 2008-08-09 23:22:24 | 2008-08-09 23:22:24 |+--------------------- If you think the article is good, you can share it so that more people can see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.