Languages
[Edit]
EN

MySql - how to convert unix timestamp to datetime?

7 points
Created by:
AnnLen
9180

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';

 

Native Advertising
50 000 ad impressions - 449$
🚀
Get your tech brand or product in front of software developers.
For more information contact us:
Red dot
Dirask - friendly IT community for everyone.

❤️💻 🙂

Join