How does MySQL get the current time and timestamp

This article introduces the relevant knowledge of "how to obtain the current time and timestamp of MySQL". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

MySQL is the most popular relational database management system, and MySQL is one of the best RDBMS applications in WEB applications.

In this introduction, you will quickly grasp the method of MySQL to obtain the current time and timestamp, and easily use the MySQL database.

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

MySQL > select now (); +-+ | now () | +-+ | 2013-04-08 20:56:19 | +-+

In addition to the now () function that gets the current date and time, there are the following functions in MySQL:

Current_timestamp (), current_timestamp,localtime (), localtime,localtimestamp-(v4.0.6), localtimestamp ()-(v4.0.6) MySQL timestamp (Timestamp) function

2. MySQL gets the 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 | +-+ "how MySQL gets the current time and timestamp" ends here. Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!