King Julien King Julien - 1 year ago 97
SQL Question

Convert Unix timestamp into human readable date using MySQL

Is there a MySQL function which can be used to convert a Unix timestamp into a human readable date? I have one field where I save Unix times and now I want to add another field for human readable dates.

Answer Source

Use from_unixtime:

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download