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.
To convert it to a readable date, use
FROM_UNIXTIME(int)
You can also get more formatting control with something like:
FROM_UNIXTIME(int, '%Y %D %M %h:%i:%s %x')
About Nate
I currently live south of Champaign, IL in an old farm house with my wife and 6 kids. I spend most of my free time keeping our house and barn in some sort of decent shape and programming for the fun of it. Of course with 6 kids there’s also a lot of diaper changing, teaching, playing, consoling, punishing, and other fun parental stuff.
Palmira Grav says
I am going to be a junior in high school in a month when school starts and I want to start looking at schools. I am really interested in creative writing and literature. What are some good schools for that? I also want to study philosophy. . . Thanks!.
Windows 7 Home Premium Key says
Magnificent goods from you, man. I’ve understand your stuff previous to and you are just extremely excellent. I really like what you’ve acquired here, really like what you’re stating and the way in which you say it. You make it entertaining and you still care for to keep it smart. I can not wait to read much more from you. This is actually a tremendous website.
Sherwood Tortora says
Awesome writing style!
Knightsbridge UGGs clearance says
I such as this article very much, wish you can write much more about this.
Emerson Shayne says
Spot on with this write-up, I actually assume this website needs much more consideration. I’ll probably be once more to learn much more, thanks for that info.
kids ugg sale says
I have observed which on the internet training gets preferred because having your diploma online has turned into a popular selection for lots of people. A lot of people possess definitely not had a opportunity to go to an ordinary college or university yet seek the raised earning possible along with a much better job that the Bachelors Degree provides. Nevertheless other people may have a diploma in one discipline however desire to go after something these people right now create an interest in.
louis vuitton watches for men says
This is my very first time i click here. I discovered therefore a number of of enjoyable stuff within your blog, particularly its dialogue. by using the a lot of comments on your content articles, I suppose I’m not the only one obtaining all of the leisure here! Keep up the actual beneficial function.
Meghan Hanoa says
Do you mind if I posted this article on my web site? I would give you credit and a link back to your site. Thanks, and if possible let me know here!