python convert string to datetime which is django time format

Question

time = "2019-02-20T04:35:48.679000+00:00"

>>> import datetime
>>> 
>>> date_time_str = "2019-02-20T04:35:48.679000+00:00"
>>> date_time_obj = datetime.datetime.strptime(date_time_str, '%Y-%m-%d %H:%M:%S.%f')

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/lib/python3.5/_strptime.py", line 510, in _strptime_datetime
    tt, fraction = _strptime(data_string, format)
  File "/usr/lib/python3.5/_strptime.py", line 343, in _strptime
    (data_string, format))
ValueError: time data '2019-02-20T04:35:48.679000+00:00' does not match format '%Y-%m-%d %H:%M:%S.%f'

The time is Django format time. Unfortunately i am storing the same in an CharField() so it is giving time as a string while fetching data from database.

How can i convert it into actual time.

CryptoFool · Accepted Answer · 2019-02-22 05:13:36Z

3

You need to account for the 'T', and I don't know how to match the "+00:00" part unless it's simply a literal that's always that value. So this works:

import datetime
date_time_str = "2019-02-20T04:35:48.679000+00:00"
date_time_obj = datetime.datetime.strptime(date_time_str, '%Y-%m-%dT%H:%M:%S.%f+00:00')

answered Feb 22, 2019 at 5:13

CryptoFool

23.4k5 gold badges31 silver badges55 bronze badges

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

1 Comment

CryptoFool Over a year ago

Ok, I admit it...@Mike's answer is what you want :) . ... unless you don't want to require python-dateutil for some reason.

Mike Olszak · Accepted Answer · 2019-02-22 05:12:51Z

2

try to use python-dateutil

install it pip install python-dateutil

and then

from dateutil import parser
dt = parser.parse("2019-02-20T04:35:48.679000+00:00")

answered Feb 22, 2019 at 5:12

Mike Olszak

4131 gold badge9 silver badges14 bronze badges

1 Comment

Mike Olszak Over a year ago

hi @kiran could you choose one answer you prefer?

Collectives™ on Stack Overflow

python convert string to datetime which is django time format

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related