convert unixtime to date

[684425]

I have a column (unix_values) in table where multiple values are stored in unix timestamp which i want to convert into date yyyy-mm-dd and copy to another column (date_values) using single query

Any help please?

[Barand]

https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_from-unixtime

[684425]

10 minutes ago, Barand said:

https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_from-unixtime

I was trying it with a subquery and got confused.

Thank you 🙂

[Barand]

Just for the record...

mysql> select * from datetest;
+------------+------+
| unix       | date |
+------------+------+
| 1576972800 | NULL |
| 1579651200 | NULL |
| 1582329600 | NULL |
+------------+------+

mysql> UPDATE datetest SET date = from_unixtime(unix);

mysql> select * from datetest;
+------------+------------+
| unix       | date       |
+------------+------------+
| 1576972800 | 2019-12-22 |
| 1579651200 | 2020-01-22 |
| 1582329600 | 2020-02-22 |
+------------+------------+