Obtain the mysql function now () of the current date and time ()

How can we get the current date and time? You can use the mysql function now () to implement this function. The following describes the mysql function for your reference.

Mysql> select now ();

+ --------------------- +
| Now () |
+ --------------------- +
| 22:20:46 |
+ --------------------- +
In addition to the now () function, MySQL also has the following mysql functions:

Current_timestamp ()
, Current_timestamp
, Localtime ()
, Localtime
, Localtimestamp -- (v4.0.6)
, Localtimestamp () -- (v4.0.6)
These date-time mysql functions are equivalent to now (). Considering that the now () function is short and easy to remember, we recommend that you always use now () to replace the mysql function listed above.

Learn more about mysql CONCAT () Functions

How to modify the default Character Set of mysql

Role of MySQL Foreign keys in Databases

How MySQL defines foreign keys

MySql stored procedure with Parameters