How to convert unix timestamp to specific format in mysql ?

[Tapan]

Hi,

I am storing dates in mysql as unix timestamps. When I am doing select staments how do i get that unix timestamp converted to this format ?

Format is: yyyy-MM-dd HH:mm:ss

Thanks.