[Blacklite]

Note that in MySQL, you can use the FROM_UNIXTIME() function to retrieve a date:

Code:

mysql> SELECT FROM_UNIXTIME(1196440219);
        -> '2007-11-30 10:30:19'
mysql> SELECT FROM_UNIXTIME(1196440219) + 0;
        -> 20071130103019.000000
mysql> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(),
    ->                      '%Y %D %M %h:%i:%s %x');
        -> '2007 30th November 10:30:59 2007'

The FROM_UNIXTIME() function uses the same format as DATE_FORMAT().