How to convert from Unix timestamp to MySQL timestamp value?

MySQL converts Unix timestamp to timestamp data type value with the help of  FROM_UNIXTIME() function.

Example

mysql> Select FROM_UNIXTIME(1508622563);
+-----------------------------+
| FROM_UNIXTIME(1508622563)   |
+-----------------------------+
| 2017-10-22 03:19:23         |
+-----------------------------+
1 row in set (0.00 sec)

Nikitha N

Published on 19-Feb-2018 11:34:35

• Related Questions & Answers
• Convert MySQL timestamp to UNIX Timestamp?
• How to convert MySQL datetime to Unix timestamp?
• Convert MySQL Unix-Timestamp format to date format?
• MySQL - Convert YYYY-MM-DD to UNIX timestamp
• How to convert Python date to Unix timestamp?
• Convert MM/DD/YY to Unix timestamp in MySQL?
• Convert dd/mm/yyyy string to Unix timestamp in MySQL?
• How to convert a Unix timestamp to time in JavaScript?
• Convert UNIX timestamp into human readable format in MySQL?
• How to convert unix timestamp string to readable date in Python?
• How to convert timestamp to datetime in MySQL?
• How to get the Unix timestamp in C#
• MySQL query to convert timestamp to month?
• Display only date from timestamp value in MySQL
• How to select date from timestamp in MySQL?