Advanced Search

Return to Snippet

Revision: 36901
at November 30, 2010 02:10 by daipratt
Initial Code 
//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
Initial URL 
http://daipratt.co.uk
Initial Description 
Convert a Drupal time stamp field into a readable format. The Drupal time stamp field is in the UNIX format.
Initial Title 
MySQL UNIX timestamp to readable date
Initial Tags 
mysql
Initial Language 
MySQL