How to convert timestamp to datetime in MySQL? -


how convert 1300464000 2011-03-18 16:00:00 in mysql?

use from_unixtime() function in mysql

remember if using framework stores in milliseconds (for example java's timestamp) have to divide 1000 obtain right unix time in seconds.


Comments