Change  "DESC" to "ASC", should fix it :)

Oh I see now- I don't think my suggestion will work. Sorry about that- I misunderstood.

That produces a sort of correct result:

03/11/2009 at 01:13:34 PM
03/11/2009 at 10:14:08 AM
03/11/2009 at 10:21:25 AM
03/11/2009 at 10:24:12 AM

When I need it to be:
03/11/2009 at 01:13:34 PM
03/11/2009 at 10:24:12 AM
03/11/2009 at 10:21:25 AM
03/11/2009 at 10:14:08 AM

Notice the AM/PM Change. That might of threw you off :)

It most certainly did. If you dont mind my asking, what type of field is this information stored in, in the table?

Is it a VARCHAR? Also, how is the time being inserted into it? Is it just like what's being returned, or is the info you're showing us post-parsed into a readable format?

Its a VARCHAR(25). It's inserted as it's shown. That's a straight copy and paste from the table, just the table name is changed. :)

OK- I found the two functions you will need to research to make this work. I began writing a script but this really is pretty involved and would take a bit of time.

These functions are extremely useful, anyways- so you should learn them to buff up on parsing data with PHP :)

Link 1- use this to separate the time format you have into sections (month, day, hour, minute, am/pm, etc)
http://us2.php.net/manual/en/function.explode.php

Link 2- use this to change * AM to "0" and * PM to "+12" (hours) to convert the time to a univeral (24 hour, IE 13:45 instead of 1:45PM) time standard
http://us2.php.net/strrpos

Then make a basic variable to sort them.

I wish I could help more but I don't have that much time to commit, on top of my own project :/

try

select str_to_date( `Date`, "%m/%d/%Y at %h:%i:%s %p" ) as date1 from tablename order by date1 desc

tkalchev,

I tried your solution, but no prevail. It returns rows, but the values are NULL.

which mysql version do you have? I've tested it on 5.0 and it woks perfect

Hmm, didn't think of a version issue.

MySQL client version: 4.1.22

Nice tkalchev...

It works perfectly, then I just pass in the returned row value to the following function I created.

Final Solution:

// RUN QUERY
SELECT STR_TO_DATE(replace(`Date`," at ",""), "%m/%d/%Y %h:%i:%s %p" ) as DateAdd FROM `TABLENAME` ORDER BY `DateAdd` DESC
 
// WHILE LOOP
$strDateTime = FormatDateTime($Row["DateAdd"]);
 
function FormatDateTime($string) {
		$strDate = substr($string,0,10);
		$strTime = trim(substr($string,10));
		
		list($strYear, $strMonth, $strDay) = explode('-', $strDate);
 
		$strTime = date('g:i:s A' , strtotime($strTime));
		
		$string = $strMonth . "/" . $strDay . "/" . $strYear . " at " . $strTime;
		return $string;
	}

Select allOpen in new window

After running it again, I realize I'm kind of in the same situation still...

SELECT str_to_date( replace( `rs_DateAdd` , ' at ', '' ) , '%m/%d/%Y %h:%i:%s %p' ) AS Date
FROM `TABLENAME`
WHERE `rs_ExtID` =79
ORDER BY `rs_DateAdd` DESC

Results:
Date
2009-03-12 09:52:22
2009-03-11 10:24:12
2009-03-11 10:21:25
2009-03-11 10:14:08
2009-03-11 13:13:34
2009-03-10 13:24:23
2009-03-10 13:23:08
2009-03-05 09:45:21

Am I thinking about this wrong? I need the date Descending, but the time from Latest to earliest.

Okay, my bad.. You're still correct. I messed up the SQL when putting it in the second time.

SELECT str_to_date( replace( `rs_DateAdd` , ' at ', '' ) , '%m/%d/%Y %h:%i:%s %p' ) AS Date
FROM `TABLENAME`
WHERE `rs_ExtID` =79
ORDER BY `Date` DESC

Thanks for the help!

SELECT str_to_date( replace( `rs_DateAdd` , ' at ', '' ) , '%m/%d/%Y %h:%i:%s %p' ) AS Date
FROM `TABLENAME`
WHERE `rs_ExtID` =79
ORDER BY `Date` DESC