How to convert JSON date & time to Python datetime?

Question

I get the date and time as string like 2014-05-18T12:19:24+04:00

I found another question explaining how to handle dates in UTC timezone (2012-05-29T19:30:03.283Z)

What should I do with +04:00 in my case (if I want to store time in UTC timezone in Python)?

Upd. I've tried to parse it like below:

dt = '2014-05-19T14:48:50+04:00'
plus_position = dt.find('+') # remove column in the timezone part
colon_pos = dt.find(':', plus_position)
dt = dt[:colon_pos] + dt[colon_pos+1:]
dt = datetime.datetime.strptime(dt, '%Y-%m-%dT%H:%M:%S%z') # '2014-05-19T14:48:50+0400'

But it fails - 'z' is a bad directive in format '%Y-%m-%dT%H:%M:%S%z'

datetime.isoformat produces a timezone with a colon. %z expects a timezone without a colon. Hahaha. Ha. =( — Ry-
– Ry- ♦, Commented May 18, 2014 at 14:34

falsetru · Accepted Answer · 2014-05-18 14:31:12Z

3

Using dateutil:

>>> import dateutil.parser
>>> dateutil.parser.parse('2014-05-18T12:19:24+04:00')
datetime.datetime(2014, 5, 18, 12, 19, 24, tzinfo=tzoffset(None, 14400))

answered May 18, 2014 at 14:31

falsetru

371k69 gold badges769 silver badges659 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

LA_ Over a year ago

Thanks, but can I do the same without dateutil? It requires six to be installed... I don't like to use many 3rd party modules with GAE environment.

Collectives™ on Stack Overflow

How to convert JSON date & time to Python datetime?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related