converting string to date some values are missing python

Question

I want to be able to convert string to date format in python. But some of the day and month are assigned to 00.

date = ['00-00-2001', '10-01-2014']

when I tried :

datetime.strptime(date[1], '%d-%m-%Y'), of course it works fine, but doing datetime.strptime(date[0], '%d-%m-%Y'), I get the following error.

time data '00-00-2001' does not match format '%d-%m-%Y'

Does 00-00-2001 really mean January 1, 2001, or does it mean something else? — user2832874
– user2832874, Commented Aug 11, 2016 at 5:51

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

According to Python Docs:

%d Day of the month as a zero-padded decimal number. 01, 02, ..., 31

%m Month as a zero-padded decimal number. 01, 02, ..., 12

None of these accept 00 as valid string.

Also see my answer at https://stackoverflow.com/a/38801552/1005215 which explains how you can use the parser from dateutil by passing a default parameter.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Aug 11, 2016 at 5:43

Nehal J Wani

16.7k3 gold badges72 silver badges93 bronze badges

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

3 Comments

Kartik Over a year ago

How does this answer the question? Telling the OP that it cannot be done is already taken care of by the Python interpreter.

Nehal J Wani Over a year ago

@Kartik The python interpreter doesn't tell the OP why the string didn't match the format.

Kartik Over a year ago

Yes, I stand corrected. "Telling the OP that it is not straightforward has already been done by the Python interpreter".

Kartik · Accepted Answer · 2016-08-11 06:20:17Z

0

Execute:

corrected_date = []
for d in dates:
    components = d.split('-')
    components = [str(c).zfill(2) if(int(c) > 0) else str(int(c) + 1).zfill(2) for c in components]
    corrected_date.extend(['-'.join(components)])

Now try your strftime on corrected_date.

answered Aug 11, 2016 at 6:20

Kartik

8,73345 silver badges78 bronze badges

Collectives™ on Stack Overflow

converting string to date some values are missing python

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related