use Time::Local;
$time = timelocal(gmtime($time_from_database));