My MySQL version is 5.6; it has a FROM_UNIXTIME
function. But it works for timestamps with 10 digits: 1447430881.
mysql> SELECT FROM_UNIXTIME(1447430881);
-> '2015-11-13 10:08:01'
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);
-> NULL
Isn't there a FROM_UNIXMILLITIME
function?