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