View Full Version : RFC 2822 formatted date in MySQL
08-13-2008, 01: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, 02:39 PM
There isn't a date format that will but you could simply store it in a varchar column.
08-13-2008, 05:10 PM
But, When i take it out of the db, i need to sort it, DESC according to date.
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.
Powered by vBulletin® Version 4.2.2 Copyright © 2015 vBulletin Solutions, Inc. All rights reserved.