使用strptime将带偏移量的时间戳转换为datetime obj [英] Convert timestamps with offset to datetime obj using strptime
问题描述
我正在使用strptime方法将格式2012-07-24T23:14:29-07:00
的时间戳转换为python中的datetime对象。问题在于结束时的时间偏移(-07:00)。没有偏移我可以成功地执行
I am trying to convert time-stamps of the format "2012-07-24T23:14:29-07:00" to datetime objects in python using strptime method. The problem is with the time offset at the end(-07:00). Without the offset i can successfully do
time_str = "2012-07-24T23:14:29"
time_obj=datetime.datetime.strptime(time_str,'%Y-%m-%dT%H:%M:%S')
但是,我尝试使用偏移量
But with the offset i tried
time_str = "2012-07-24T23:14:29-07:00"
time_obj=datetime.datetime.strptime(time_str,'%Y-%m-%dT%H:%M:%S-%z').
但是它给出了一个值错误,说z是一个坏的指令。
But it gives a Value error saying "z" is a bad directive.
任何想法的工作?
推荐答案
Python 2 strptime()
函数确实不支持时区的%z
格式(因为底层的 time.strptime()
功能不支持它)。您有两个选项:
The Python 2 strptime()
function indeed does not support the %z
format for timezones (because the underlying time.strptime()
function doesn't support it). You have two options:
-
使用
strptime解析时忽略时区
:
time_obj = datetime.datetime.strptime(time_str[:19], '%Y-%m-%dT%H:%M:%S')
使用 dateutil
模块,它的解析功能 处理时区:
from dateutil.parser import parse
time_obj = parse(time_str)
在命令提示符下快速演示:
Quick demo on the command prompt:
>>> from dateutil.parser import parse
>>> parse("2012-07-24T23:14:29-07:00")
datetime.datetime(2012, 7, 24, 23, 14, 29, tzinfo=tzoffset(None, -25200))
您还可以升级到Python 3.2或更新版本,时区支持已经改进为%z
将工作,只要您从输入中删除最后一个:
, -
从%z
之前:
You could also upgrade to Python 3.2 or newer, where timezone support has been improved to the point that %z
would work, provided you remove the last :
from the input, and the -
from before the %z
:
>>> import datetime
>>> time_str = "2012-07-24T23:14:29-07:00"
>>> datetime.datetime.strptime(time_str, '%Y-%m-%dT%H:%M:%S%z')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/Users/mj/Development/Library/buildout.python/parts/opt/lib/python3.4/_strptime.py", line 500, in _strptime_datetime
tt, fraction = _strptime(data_string, format)
File "/Users/mj/Development/Library/buildout.python/parts/opt/lib/python3.4/_strptime.py", line 337, in _strptime
(data_string, format))
ValueError: time data '2012-07-24T23:14:29-07:00' does not match format '%Y-%m-%dT%H:%M:%S%z'
>>> ''.join(time_str.rsplit(':', 1))
'2012-07-24T23:14:29-0700'
>>> datetime.datetime.strptime(''.join(time_str.rsplit(':', 1)), '%Y-%m-%dT%H:%M:%S%z')
datetime.datetime(2012, 7, 24, 23, 14, 29, tzinfo=datetime.timezone(datetime.timedelta(-1, 61200)))
这篇关于使用strptime将带偏移量的时间戳转换为datetime obj的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!