get actual date from unix time(Mysql)

FROM_UNIXTIME(unix_timestamp),
FROM_UNIXTIME(unix_timestamp,format)

Returns a representation of the
unix_timestamp argument as a value
in 'YYYY-MM-DD HH:MM:SS' or
YYYYMMDDHHMMSS format, depending on whether
the function is used in a string or numeric context. The value
is expressed in the current time zone.
unix_timestamp is an internal
timestamp value such as is produced by the
UNIX_TIMESTAMP() function.

If format is given, the result is
formatted according to the format
string, which is used the same way as listed in the entry for
the DATE_FORMAT() function.

mysql> SELECT FROM_UNIXTIME(875996580);
        -> '1997-10-04 22:23:00'

Powered by ScribeFire.