FROM_UNIXTIME(int)You can also get more formatting control with something like:FROM_UNIXTIME(int, '%Y %D %M %h:%i:%s %x')