string convert to date time in python

Question

I have a list of date time strings like this.

16-Aug-2019

I want to convert the string to 2019-08-01 this date format, and I have tried on this code , but it's getting me an error.

formatd_date = datetime.strptime(formatd_date, '%y-%m-%d')

ValueError: time data 'As-of' does not match format '%y-%m-%d'

If any can help, it will be huge thank.

Subhrajyoti Das · Accepted Answer · 2019-08-19 10:24:59Z

2

Convert to datetime format and then convert to string format you want to:

>>> from datetime import datetime
>>> a = "16-Aug-2019"
>>> datetime.strptime(a, "%d-%b-%Y").strftime("%Y-%m-%d")
'2019-08-16'

answered Aug 19, 2019 at 10:24

Subhrajyoti Das

2,7203 gold badges26 silver badges38 bronze badges

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

1 Comment

Thank you for saving me. It's working properly @subhrajyoti-das

jpaul · Accepted Answer · 2019-08-19 10:53:53Z

1

Just fails because %y is 2-digit year. Use %Y for 4-digit year.

answered Aug 19, 2019 at 10:48

jpaul

3151 silver badge5 bronze badges