FROM_UNIXTIME


select user_id, username, from_unixtime(user_regdate) from phpbb3_users where user_lastvisit = 0 order by user_regdate;