mysql FROM_UNIXTIME

SELECT UNIX_TIMESTAMP('2005-03-27 03:00:00');
1111885200
SELECT UNIX_TIMESTAMP('2005-03-27 02:00:00');
1111885200
SELECT FROM_UNIXTIME(1111885200);
2005-03-27 03:00:00 
-------------------------

select 
FROM_UNIXTIME(SUBSTRING(stime,1,10)),FROM_UNIXTIME(SUBSTRING(stime,1,10)),time
from e;