Time data format in python

Question

I am reading dates from csv to python in the form of 2017-01-04. I am trying to process dates like

from datetime import datetime       
day1 = datetime.strptime(date1, date_format)

where I use date_format = "%y-%m-%d"

However, when I process the data, I get the error:

time data '2017-01-04' does not match format '%y-%m-%d'

What should it be?

It's "%Y-%m-%d" upper-case Y for 4 digit years, see the docs — EdChum
– EdChum, Commented Jun 28, 2017 at 8:04

omri_saadon · Accepted Answer · 2017-06-28 08:06:08Z

4

Y - Year with century as a decimal number.

y - Year without century as a zero-padded decimal number.

Therefore, you should use Upper Y.

For more information about the formats, you can see it all in here

answered Jun 28, 2017 at 8:06

omri_saadon

10.7k8 gold badges36 silver badges58 bronze badges

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

Comments

EvgenyKolyakov · Accepted Answer · 2017-06-28 08:05:30Z

0

Something like :

from datetime import datetime
day1 = datetime.utcnow().strptime('2017-01-04', '%Y-%m-%d')

answered Jun 28, 2017 at 8:05

EvgenyKolyakov

3,7012 gold badges24 silver badges35 bronze badges

Roko · Accepted Answer · 2017-06-28 08:12:04Z

0

You can run it-This code run successfully and print-2017-01-04 00:00:00

     from datetime import datetime
     day1 = datetime.utcnow().strptime('2017-01-04', '%Y-%m-%d')
     print(day1)

answered Jun 28, 2017 at 8:12

Roko

1491 silver badge10 bronze badges