Sorting Dates in this format: Jul 21 2001

From: Date: Tue, 07 Aug 2001 10:09:47 +0000
Subject: Sorting Dates in this format: Jul 21 2001
Groups: php.general 
Request: Send a blank email to php-general+get-62001@lists.php.net to get a copy of this message
I have a bunch of dates like this: Jul 24 2001 Jul 31 2001 Aug 7 2001 I need to sort it from oldest to newest, but I can't devise a way that works. And they are text fields in MySQL so that won't sort it correctly either. Can anyone point me in the right direction?

« previous php.general (#62001) next »