...

View Full Version : RFC 2822 formatted date in MySQL



the-dream
08-13-2008, 01:33 PM
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
08-13-2008, 02:39 PM
There isn't a date format that will but you could simply store it in a varchar column.

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

djm0219
08-13-2008, 06: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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum