Convert Unix timestamp into human readable date using MySQL

by

Use FROM_UNIXTIME():

SELECT
  FROM_UNIXTIME(timestamp) 
FROM 
  your_table;

See also: MySQL documentation on FROM_UNIXTIME().

More Related Contents:

  1. MySQL convert date string to Unix timestamp
  2. Use MySQL to determine whether today is a user’s birthday
  3. mysql_fetch_array() expects parameter 1 to be resource, boolean given in [closed]
  4. How to group by two rows in a column
  5. How to perform grouped ranking in MySQL
  6. How to abort INSERT operation in MySql trigger?
  7. Mysql or/and precedence?
  8. MySQL “Group By” and “Order By”
  9. CHECK constraint in MySQL is not working
  10. MySQL Query to select data from last week?
  11. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  12. Migrate from Oracle to MySQL
  13. Which is more efficient: Multiple MySQL tables or one large table?
  14. Are there disadvantages to using a generic varchar(255) for all text-based fields?
  15. How to skip columns in CSV file when importing into MySQL table using LOAD DATA INFILE?
  16. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  17. MySQL InnoDB foreign key between different databases
  18. Images in MySQL
  19. Replace Into Query Syntax
  20. Loading utf-8 encoded text into MySQL table
  21. adding RMySQL package to R fails (on Windows)?
  22. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  23. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  24. Why MySQL is giving error “Not allowed to return a result set from a function”?
  25. How to store decimal in MySQL?
  26. MySQL cumulative sum grouped by date
  27. Where I can find a list of “mysqldump” exit codes?
  28. MySQL – Cannot insert NULL value in column, but I have a default value specified?
  29. How to escape apostrophe (a single quote) in MySql?
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment