MySQL數(shù)據(jù)庫(kù)中的datetime類(lèi)型日期之間是用'-'分割担敌，時(shí)間用':'分割
對(duì)于國(guó)內(nèi)網(wǎng)站中的時(shí)間都相對(duì)容易處理柄错，然而國(guó)外大多數(shù)網(wǎng)站會(huì)使用月份或月份的縮寫(xiě)等等一些亂七八糟格式的時(shí)間苦酱，這時(shí)候在python中如何處理呢疫萤？
可以使用python的datetime的strptime()和strftime()處理
兩個(gè)函數(shù)都需要用到時(shí)間日期的格式化字符串敢伸，格式化字符串及其對(duì)應(yīng)的含義如下：
%a Abbreviated weekday name
%A Full weekday name
%b Abbreviated month name
%B Full month name
%c Date and time representation appropriate for locale
%d Day of month as decimal number (01 - 31)
%H Hour in 24-hour format (00 - 23)
%I Hour in 12-hour format (01 - 12)
%j Day of year as decimal number (001 - 366)
%m Month as decimal number (01 - 12)
%M Minute as decimal number (00 - 59)
%p Current locale's A.M./P.M. indicator for 12-hour clock
%S Second as decimal number (00 - 59)
%U Week of year as decimal number, with Sunday as first day of week (00 - 51)
%w Weekday as decimal number (0 - 6; Sunday is 0)
%W Week of year as decimal number, with Monday as first day of week (00 - 51)
%x Date representation for current locale
%X Time representation for current locale
%y Year without century, as decimal number (00 - 99)
%Y Year with century, as decimal number
%z, %Z Time-zone name or abbreviation; no characters if time zone is unknown
%% Percent sign
例：
import datetime
t = 'Sun, 04 Dec 2016 23:09:37 +0000'
c = datetime.datetime.strptime(t,'%a, %d %b %Y %H:%M:%S +0000')
tim = c.strftime('%Y-%m-%d %H:%M:%S')
print tim
參考鏈接：http://www.cnblogs.com/65702708/archive/2011/04/17/2018936.html
http://www.jb51.net/article/62518.htm
http://www.jb51.net/article/47957.htm
http://www.sharejs.com/codes/python/8664
http://blog.csdn.net/caisini_vc/article/details/5619954
