Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - What is the function of MySQL to get the current time? What is the purpose of formatting dates?
What is the function of MySQL to get the current time? What is the purpose of formatting dates?
Just use now () to get the current time. Format the time in the database with DATE _ Format T(DATE, format).

Format a date or a date and time value date according to the format string format, and return the result string.

MySQL is a relational database management system, which was developed by Swedish MySQL AB company and currently belongs to Oracle. MySQL is the most popular relational database management system, and MySQL is one of the best RDBMS (Relational Database Management System) applications in WEB applications. MySQL is a relational database management system, which saves data in different tables instead of all data in a big warehouse, thus improving the speed and flexibility. SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts dual authorization strategy (this entry "authorization strategy"), which is divided into community version and commercial version. Because of its small size, high speed and low total cost of ownership, especially open source, MySQL is generally chosen as the website database for the development of small and medium-sized websites. Because of its excellent performance, the community version can form a good development environment with PHP and Apache.