Python中字符串(string)與日期(datetime)物件轉換
功能
需使用datetime套件,在讀取資料庫或檔案中的時間字符串時會需要用到,此篇介紹如何解析日期時間的字符串成datetime物件,以及將datetime物件轉成日期時間的字符串。
語法
- 日期時間字符串(string)轉datetime物件
datetime.datetime.strptime("日期時間字符串","字符串的格式")
- datetime物件轉日期時間字符串(string)
datetime物件.strftime('str日期時間格式,可參考下表')
str日期時間格式轉換表:
%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
|
範例
- 日期時間字符串(string)轉datetime物件
>>> import datatime
>>> datetime.datetime.strptime("2019-04-22 20:43:53.762",'%Y-%m-%d %H:%M:%S.%f')
datetime.datetime(2019, 4, 22, 20, 43, 53, 762000)
- datetime物件轉日期時間字符串(string)
>>> import datetime
>>> now = datetime.datetime.now()
>>> now.strftime('%Y-%m-%d')
'2019-08-06'