How to convert seconds to time in mysql

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.

mysql> SELECT FROM_UNIXTIME(1150051270);
+---------------------------+
| FROM_UNIXTIME(1150051270) |
+---------------------------+
| 2006-06-12 02:41:10       |
+---------------------------+
1 row in set (0.00 sec)

[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!