RFC 2822 formatted date in MySQL

[the-dream]

Is there a column type in MySQL that accepts dates in the RFC 2822 date format.

//AKA
date('r');

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

[djm0219]

There isn't a date format that will but you could simply store it in a varchar column.

[the-dream]

But, When i take it out of the db, i need to sort it, DESC according to date.

[djm0219]

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.