SQL conversion of php timestamp to readable date

[antun]

I often save times in a mySQL database as UNIX timestamps (php function: time()). Is there a way to convert (in SQL) this timestamp to a readable string?

-Antun

[zcketcher]

http://www.mysql.com/doc/en/Date_and_time_functions.html

[antun]

I had actually looked at that page already, but missed the function that I was looking for:

FROM_UNIXTIME(unix_timestamp [,format])

Thanks,

Antun