Format mismatch while converting the string to datetime format

Question

My aim is to convert a string into datetime format. The string format is 2020-10-02 09:00:00.000 I tried below methods and both are giving me a format mismatch error.

timerangestart = "2020-10-02 09:00:00.000"
timerangestart = timerangestart[:-4]
my_time = datetime.strptime(timerangestart, '%y-%m-%d %H:%M:%S')

timerangestart = "2020-10-02 09:00:00.000"
timerangestart = timerangestart + "000"
my_time = datetime.strptime(timerangestart, '%y-%m-%d %H:%M:%S.%f')

ValueError: time data '2020-10-02 09:00:00' does not match format '%y-%m-%d %H:%M:%S'

What is it that I am doing wrong?

You could have used datetime.fromisoformat in the first place. — FObersteiner
– FObersteiner, Commented Oct 3, 2020 at 12:25

baduker · Accepted Answer · 2020-10-03 11:51:49Z

1

Your %y is wrong. It should be %Y.

Try this:

from datetime import datetime

timerangestart = "2020-10-02 09:00:00.000"
timerangestart = timerangestart[:-4]
my_time = datetime.strptime(timerangestart, '%Y-%m-%d %H:%M:%S')
print(my_time)

timerangestart = "2020-10-02 09:00:00.000"
timerangestart = timerangestart + "000"
my_time = datetime.strptime(timerangestart, '%Y-%m-%d %H:%M:%S.%f')

print(my_time)

Output:

2020-10-02 09:00:00
2020-10-02 09:00:00

Here's a handy reference table of strftime() formatting.

answered Oct 3, 2020 at 11:51

baduker

20.2k9 gold badges44 silver badges64 bronze badges

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

1 Comment

FObersteiner Over a year ago

Have a look at docs.python.org/3/library/…

Collectives™ on Stack Overflow

Format mismatch while converting the string to datetime format

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related