In mysql, you can use the FROM_UNIXTIME() function to convert seconds to time. This function can convert the timestamp (total seconds) into a common format date and time value. The syntax is "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 to time.
FROM_UNIXTIME(date)
The function converts the UNIX timestamp (the total number of seconds from January 1, 1970 00:00:00 GMT to the present) Convert to a date-time value in common format ('YYYY-MM-DD HH:MM:SS' or a date-time value in YYYYMMDDHHMMSS format).
[Example] Use the FROM_UNIXTIME(date) function to convert UNIX timestamps into common format time.
1 2 3 4 5 6 7 |
|
[Related recommendations: mysql video tutorial]
The above is the detailed content of How to convert seconds to time in mysql. For more information, please follow other related articles on the PHP Chinese website!