How can MySQL convert milliseconds into days?

1 year ago
Ava Mitchell
1 minute

You can use the following SQL statement to convert milliseconds to days:

SELECT 
    TIMESTAMPDIFF(DAY, '1970-01-01', FROM_UNIXTIME(millisecond / 1000)) AS days
FROM your_table;

The column name storing milliseconds is “millisecond”, and the table name is “your_table”. This SQL statement will convert milliseconds to days and display the result in a column called “days”.

bannerAds