- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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)
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 to convert from Unix timestamp to MySQL timestamp value?
- How can I convert 1st January of the current year into epoch?
- How do I convert a datetime to a UTC timestamp in Python?
- How to convert timestamp to datetime in MySQL?
- How can I count the number of days in MySQL?
- How can I get seconds since epoch in JavaScript?
- MySQL query to convert a string into a month (Number)?
Advertisements