Convert Moodle Timestamp fields to Date

I get really frustrated with Moodle for using int fields to store dates.  They store it in the Unix (Epoch) format.  Here's how to make it more readable.
Author: Nate Baxley
Published Date:7/25/2008
To convert it to a readable date, use 
FROM_UNIXTIME(int)

You can also get more formatting control with something like:
FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y %D %M %h:%i:%s %x')
RSS Feed Log In to access RSS feeds.


Remember me on this computer

This Item Tagged as

Hover over an item above for
more information