MySQL Timestamp Conversion

SELECT TIME(FROM_UNIXTIME(SUBSTRING('1365835646039', 1, 10))) AS Uhrzeit;