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.

Possible duplicate of [Converting string into datetime](https://stackoverflow.com/questions/466345/converting-string-into-datetime) — Prathik Kini, Aug 19 '19 at 10:23
https://stackoverflow.com/questions/466345/converting-string-into-datetime#466376 — Reegan Miranda, Aug 19 '19 at 10:28

score 2 · Accepted Answer · answered Aug 19 '19 at 10:24

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 '19 at 10:24

Subhrajyoti Das

1

Thank you for saving me. It's working properly @subhrajyoti-das – Haz Aug 19 '19 at 10:28

jpaul · Answer 2 · 2019-08-19T10:53:53.550

1

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

edited Aug 19 '19 at 10:53

answered Aug 19 '19 at 10:48

jpaul

2 Answers2