CODEWITHSUNDEEP
pythondatetime
Adam
Adam

Reputation: 2552

Convert date string to Datetime Python Format Error

I know there are a lot of answers to this question online, but none of them have worked for me. I am trying to convert a date string into a Datetime object, of the following format: yyyy-mm-dd

My date_string is '2017-02-02T00:00:00Z'

I am trying to convert it by doing date_value = datetime.datetime.strptime(date_string, '%Y%m%d') but I'm getting the following error:

ValueError: time data '"2017-02-02T00:00:00Z"' does not match format '%Y%m%d'

Also, should I be worried about the double quotes around my date_string string?

Upvotes: 0

Views: 921

Answers (2)

Khaleel OBrien
Khaleel OBrien

Reputation: 21

The solution is to parse your date_string first, and that should help. Using strptime() right away on an unparsed datetime string can sometimes cause problems. Also you shouldn't worry about your double quotes, it's fine.

First, install the python-dateutil library if you haven't already (pip install python-dateutil at the command line). Then test the solution with the following code.

import datetime
import dateutil.parser

date_string = '2017-02-02T00:00:00Z'

#we parse the string, it becomes a datetime object
parsed_date_string = dateutil.parser.parse(date_string)
print(parsed_date_string)

#output looks like this: 2017-02-02 00:00:00+00:00

#now your statement will work
date_value = datetime.datetime.strptime(str(parsed_date_string), '%Y-%m-%d %H:%M:%S%z')
print(date_value)

#output will also be: 2017-02-02 00:00:00+00:00

The strptime() statement worked this time because we parsed our date first with parse(). Note also that to use strptime() we need to cast our parsed_date_string back to a string because parse() converts our original string to an object of class datetime.datetime and strptime() is expecting a string.

Hopefully that helped.

Upvotes: 1

Whole Brain
Whole Brain

Reputation: 2167

The second argument in the method strptime is the pattern of your string.

Here is the full list of available code formats. https://docs.python.org/3/library/datetime.html#strftime-and-strptime-format-codes

All the remaining "non-informative" characters in your string can simply be put as-is in there correct places.

Thanks to @MrFuppes for this info: you should also parse the trailing "Z" as %z. This will signal python that it's a UTC datetime and not a local datetime.

Your code should be :

date_string = '2017-02-02T00:00:00Z'
date_value = datetime.datetime.strptime(date_string, '%Y-%m-%dT%H:%M:%S%z')

As for the extra quotes, that's not wanted. You should try this beforehand :

date_string = date_string.strip("'").strip('"')

If strip() didn't work, you can call eval instead (usually not recommended) :

date_string = eval(date_string)

Upvotes: 1

Related Questions