How to display the current time in MySQL

Display the current time

Command: select now().

Function: Display the current time.

Application scenarios: Creation time, modification time and other default values.

Example:

mysql> select now();
+---------------------+
| now()  |
+---------------------+
| 2017-12-27 20:14:56 |
+---------------------+
1 row in set (0.00 sec)

The above is the detailed content of How to display the current time in MySQL. For more information, please follow other related articles on the PHP Chinese website!