View Full Version : RFC 2822 formatted date in MySQL

08-13-2008, 12:33 PM
Is there a column type in MySQL that accepts dates in the RFC 2822 date format.


RFC 2822 formatted date Example: Thu, 21 Dec 2000 16:01:07 +0200

08-13-2008, 01:39 PM
There isn't a date format that will but you could simply store it in a varchar column.

08-13-2008, 04:10 PM
But, When i take it out of the db, i need to sort it, DESC according to date.

08-13-2008, 05:18 PM
Then you'll need to parse out the actual date and time, convert it to a Unix style timestamp and store it that way if you want to be able to manipulate/retrieve it in a specific order.