Display datetime number as Year-Month-Day Time

I have a table with datetime info in one column. (integer - size11)

example: 1312338492

is there a way to display this in a human readable form?

David P.