In MySQL, how can I convert a number of seconds into TIMESTAMP?

It is exactly reverse of UNIX_TIMESTAMP() and can be done with the help of FROM_UNIXTIME() function. For example, 11576070 seconds would be TIMESTAMP ‘1970-05-15 05:04:30’.

mysql> Select FROM_UNIXTIME(11576070);
+--------------------------------+
| FROM_UNIXTIME(11576070)        |
+--------------------------------+
|      1970-05-15 05:04:30       |
+--------------------------------+
1 row in set (0.00 sec)

Sravani S

Published on 19-Feb-2018 07:03:36

• Related Questions & Answers
• How I can convert a Python Tuple into Dictionary?
• Convert UNIX timestamp into human readable format in MySQL?
• How can I convert Python strings into tuple?
• Convert MySQL timestamp to UNIX Timestamp?
• How can I convert 'HH:MM:SS ' format to seconds in JavaScript
• How can I convert the epoch stored in MySQL table into readable dates?
• Python program to convert seconds into hours, minutes and seconds
• How can I convert a bytes array into JSON format in Python?
• How can I convert 1st January of the current year into epoch?
• How to convert from Unix timestamp to MySQL timestamp value?
• How do I convert a datetime to a UTC timestamp in Python?
• How can I count the number of days in MySQL?
• How to convert timestamp to datetime in MySQL?
• PHP program to convert a given timestamp into time ago
• MySQL query to convert a string into a month (Number)?