converting json timestamp to datetime in python

Question

How can I convert '2021-11-21T18:57:18.000+01:00' from json to datetime in Python?

  timestamp = datetime.datetime.strptime(timestamp, "%Y-%m-%dT%H:%M:%S.%fZ")

is giving me error:

ValueError: time data '2021-11-21T18:57:18.000+01:00' does not match format '%Y-%m-%dT%H:%M:%S.%fZ'

Python 3.7+: use fromisoformat, it is more efficient.

FObersteiner
– FObersteiner

2021-11-21 19:38:10 +00:00
Commented Nov 21, 2021 at 19:38 — FObersteiner
– FObersteiner, Commented Nov 21, 2021 at 19:38

rdas · Accepted Answer · 2021-11-21 18:07:55Z

1

Your formatting string is slightly wrong. You need %z to parse the zone offset:

from datetime import datetime

timestamp = '2021-11-21T18:57:18.000+01:00'
timestamp = datetime.strptime(timestamp, "%Y-%m-%dT%H:%M:%S.%f%z")

print(timestamp)

Result:

2021-11-21 18:57:18+01:00

answered Nov 21, 2021 at 18:07

rdas

21.4k6 gold badges39 silver badges48 bronze badges

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

1 Comment

Alexander Brandhaug Over a year ago

Thanks alot!! Really appreciate it

Collectives™ on Stack Overflow

converting json timestamp to datetime in python

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