What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » MySQL Date/time help?

MySQL Date/time help?
Author: Message:
Jimbo
Veteran Member
*****

Avatar

Posts: 1650
Reputation: 18
32 / Male / Flag
Joined: Jul 2006
O.P. MySQL Date/time help?
I have a mysql table that stores date/time in the format of "01/02/10 07:06:33", but when listing that table using PHP, and ordering by date/time, the 2010 records appear at the end, whereas, the latest 2009 records, so from the 31st of December appear at the top. Is there anyway to get around this? or to "SELECT *", but then print in the reverse order?


This post was edited on 01-06-2010 at 05:35 PM by Jimbo.
01-06-2010 05:33 PM
Profile E-Mail PM Find Quote Report
« Next Oldest Return to Top Next Newest »

Messages In This Thread
MySQL Date/time help? - by Jimbo on 01-06-2010 at 05:33 PM
RE: MySQL Date/time help? - by absorbation on 01-06-2010 at 06:15 PM
RE: MySQL Date/time help? - by Jimbo on 01-06-2010 at 06:51 PM
RE: MySQL Date/time help? - by absorbation on 01-06-2010 at 07:10 PM
RE: MySQL Date/time help? - by Spunky on 01-06-2010 at 07:20 PM
RE: MySQL Date/time help? - by Lou on 01-06-2010 at 07:35 PM
RE: MySQL Date/time help? - by Spunky on 01-06-2010 at 07:42 PM
RE: MySQL Date/time help? - by Jimbo on 01-06-2010 at 08:14 PM
RE: MySQL Date/time help? - by Adeptus on 01-07-2010 at 12:03 AM
RE: MySQL Date/time help? - by Jimbo on 01-07-2010 at 01:42 PM
RE: MySQL Date/time help? - by Adeptus on 01-07-2010 at 03:51 PM


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On