Convert BIGINT to DATE format

Hi..

I have a mySQL query like the following:

SELECT wo.CREATEDTIME FROM wo

The result is supposed to be a list of date in a human-readable date format (i.e. 26 Jul 2006, 13:40:03) instead of a BIGINT value (i.e. 1153896003593).

Pls advise how to convert the BIGINT value into a human-readable date format. Tks.