MySQL UNIX timestamp to readable date
Convert a Drupal time stamp field into a readable format. The Drupal time stamp field is in the UNIX format.
Copy this code and paste it in your HTML
//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
URL: http://daipratt.co.uk
Report this snippet
Comments
Subscribe to comments