Extract Date-Month_year from utc format string python

Question

I have a using below code to extract date-month-year from the string of a date however it is giving me

time data '2020-05-11T04:47:54.530000' does not match format '%Y-%m-%d %H:%M:%S.%f'

error, can anyone help?

from datetime import datetime
cr_date="2020-05-11T04:47:54.530000"
datetime.strptime(cr_date, '%Y-%m-%d %H:%M:%S.%f').strftime('%m/%d/%Y')

this clearly is a ISO 8601 compatible string, so if you're on Python 3.7 or higher, use the built-ins, see my answer below. fromisoformat is also much faster than strptime, see here. — FObersteiner
– FObersteiner, Commented May 11, 2020 at 8:06

dt170 · Accepted Answer · 2020-05-11 08:32:37Z

1

Regarding your own code just add T see the following:

    from datetime import datetime
    cr_date="2020-05-11T04:47:54.530000"

    date_object = datetime.strptime(cr_date, '%Y-%m-%dT%H:%M:%S.%f').strftime('%m/%d/%Y')

Another way to solve this is using regex ,

    import re
    from datetime import datetime

    cr_date="2020-05-11T04:47:54.530000"
    match = re.search(r'\d{4}-\d{2}-\d{2}', cr_date)
    date = datetime.strptime(match.group(), '%Y-%m-%d').date()

edited May 11, 2020 at 8:32

answered May 11, 2020 at 8:09

dt170

5053 silver badges12 bronze badges

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

3 Comments

FObersteiner Over a year ago

why so complicated and use regex? why not just split on 'T'? ;-)

dt170 Over a year ago

@MrFuppes sorry if regex is to complex for you but its another approach to solve the issue.

FObersteiner Over a year ago

Python PEP20: Simple is better than complex.

FObersteiner · Accepted Answer · 2020-05-11 08:09:54Z

1

if you use Python 3.7 or higher, use fromisoformat:

from datetime import datetime
cr_date="2020-05-11T04:47:54.530000"

datetime.fromisoformat(cr_date)
# datetime.datetime(2020, 5, 11, 4, 47, 54, 530000)

you can strftime that however you want now, e.g.

datetime.fromisoformat(cr_date).strftime('%m/%d/%Y')
# '05/11/2020'

edited May 11, 2020 at 8:09

answered May 11, 2020 at 8:04

FObersteiner

26.1k9 gold badges60 silver badges94 bronze badges

Collectives™ on Stack Overflow

Extract Date-Month_year from utc format string 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