MySQL数据库中的datetime类型日期之间是用'-'分割,时间用':'分割
对于国内网站中的时间都相对容易处理,然而国外大多数网站会使用月份或月份的缩写等等一些乱七八糟格式的时间,这时候在python中如何处理呢?
可以使用python的datetime的strptime()和strftime()处理
两个函数都需要用到时间日期的格式化字符串,格式化字符串及其对应的含义如下:
%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