EN
MySql - how to convert unix timestamp to datetime?
7
points
Using MySql it is possible to convert UNIX timestamp to datetime in following way.
1. Built-in FROM_UNIXTIME function example
This example shows a new column with timestamp converted to a more readable form.
SELECT *, FROM_UNIXTIME(`sent_at`) AS `sent_at_datetime`
FROM `messages`
WHERE `sender_name` = 'John';