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