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

This article mainly introduces "how mysql turns seconds into time". In daily operation, I believe many people have doubts about how mysql turns seconds into time. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "how mysql turns seconds into time". Next, please follow the editor to study!

In mysql, you can use the FROM_UNIXTIME () function to convert seconds to time, which converts the timestamp (total seconds) into a date-time value in a normal format, with the syntax "SELECT FROM_UNIXTIME (date);".

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

In mysql, you can use the FROM_UNIXTIME () function to convert seconds into time.

The FROM_UNIXTIME (date) function converts the UNIX timestamp (the total number of seconds since 00:00:00 GMT on January 1, 1970) to a date-time value in normal format (a date-time value in 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS format).

[example] use the FROM_UNIXTIME (date) function to convert UNIX timestamps into normal format time.

Mysql > SELECT FROM_UNIXTIME (1150051270) +-- + | FROM_UNIXTIME (1150051270) | +-- + | 0-06-12 02:41:10 | +-- + 1 row in set (2006 sec) so far The study on "how mysql turns seconds into time" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.