Use FROM_UNIXTIME() : SELECT FROM_UNIXTIME(timestamp) FROM your_table;. See also: MySQL documentation on FROM_UNIXTIME() . ... <看更多>

Now I want to get the date from a milliseconds timestamp (e.g. 1556948248000), so using FROM_UNIXTIME I got NULL . mysql> SELECT FROM_UNIXTIME(1556948248000); - ... ... <看更多>