How to obtain system time in MySQL using NOW(), SYSDATE(), CURRENT_TIMESTAMP(), LOCALTIME() functions

NOW(), SYSDATE(), CURRENT_TIMESTAMP(), LOCALTIME(): Get the current date and time of the system

SELECT NOW() 
SELECT SYSDATE() 
SELECT CURRENT_TIMESTAMP() 
SELECT CURRENT_TIMESTAMP 
SELECT LOCALTIME() 
SELECT LOCALTIME

-> 2016-01-16 17:44:41
-> 2016-01-16 17:44:41
-> 2016-01-16 17:44:41
-> 2016-01-16 17:44:41
-> 2016-01-16 17:44:41
-> 2016-01-16 17:44:41

The above is the detailed content of How to obtain system time in MySQL using NOW(), SYSDATE(), CURRENT_TIMESTAMP(), LOCALTIME() functions. For more information, please follow other related articles on the PHP Chinese website!