How to convert timestamp to datetime in MySQL?

by

Use the FROM_UNIXTIME() function in MySQL

Remember that if you are using a framework that stores it in milliseconds (for example Java’s timestamp) you have to divide by 1000 to obtain the right Unix time in seconds.

More Related Contents:

  1. How can I select data from different tables?
  2. How do I query between two dates using MySQL?
  3. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  4. How to reset mysql root password?
  5. Binary Data in MySQL [closed]
  6. Can a table field contain a hyphen?
  7. Select mysql query between date?
  8. MySQL COUNT DISTINCT
  9. mysql -> insert into tbl (select from another table) and some default values [duplicate]
  10. Convert MySQL schema to Github Wiki?
  11. How can I get rid of these comments in a MySQL dump?
  12. How to create relationships in MySQL
  13. MySQL error 1436: Thread stack overrun, with simple query
  14. MySQL Removing Some Foreign keys
  15. node.js + mysql connection pooling
  16. Bug? #1146 – Table ‘xxx.xxxxx’ doesn’t exist
  17. SQL Order By Count
  18. What resources exist for Database performance-tuning? [closed]
  19. dump all mysql tables into separate files automatically?
  20. Mysql Join Two tables on keys
  21. Getting percentage of “Count(*)” to the number of all items in “GROUP BY”
  22. mysql: connection refused when trying to connect to localhost using remote IP
  23. Surpassing MySQL’s TIME value limit of 838:59:59
  24. MySQL for replace with wildcard
  25. Incorrect integer value: ” for column ‘id’ at row 1
  26. mysql select distinct rows into a comma delimited list column
  27. Select from same table as an Insert or Update
  28. How do I limit the number of rows per field value in SQL?
  29. How to find nearest location using latitude and longitude from SQL database?
  30. Are Users ‘User’@’%’ and ‘User’@’localhost’ not the same?

Leave a Comment