//For example
SELECT users.name, pnts.points, FROM_UNIXTIME(pnts.time_stamp,'%Y %D %M %h:%i:%s') AS date, pnts.description, pnts.reference, pnts.operation, users.mail
FROM userpoints_txn pnts
LEFT JOIN users users ON users.uid = pnts.uid
WHERE 1

http://daipratt.co.uk

Convert a Drupal time stamp field into a readable format. The Drupal time stamp field is in the UNIX format.

MySQL UNIX timestamp to readable date

mysql

MySQL