time_t data type, and show the number of milliseconds since
1970-01-01 00:00:00 UTC.
ROUND(UNIX_TIMESTAMP(NOW(3)) * 1000.0, 0)
If you have
SELECT ROUND(UNIX_TIMESTAMP(column) * 1000.0, 0)
If your column contains