Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to obtain the current time of the system in MySQL, the quality of the article content is high, so Xiaobian shares it with you as a reference, I hope you have a certain understanding of relevant knowledge after reading this article.

MySQL function to get the current system time

Environment: MySQL Server 5.1

Problem: MySQL function to get current system time

Solution:

The NOW() function returns the current date and time as 'Y-MM-DD HH:MM: SS', which can be stored directly in the DATETIME field.

CURDATE() returns today's date in the format 'Y-MM-DD', which can be saved directly to the DATE field.

CURTIME() returns the current time in the format 'HH:MM: SS', which can be stored directly in the TIME field.

www.2cto.com

Examples:

SQL：

[sql]

select now() as the current date and time;

select curdate() as today's date;

select curtime() as current time;

How to get the current time of the system in MySQL is shared here. I hope the above content can be of some help to everyone and learn more. 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.