// 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 all