Languages
[Edit]
EN

MySql - how to convert unix timestamp to datetime?

7 points
Created by:
AnnLen
13050

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

 

MySQL - dates

Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join