Python Datetime object

Question

I am currently having an issue converting an incoming datetime string to a datetime object using Python's built in strptime() method. Here is what I currently have:

def fixDateTimeField(datetimeString):
    # Convert from 2012-08-07T00:00:00Z to 2012-08-07T00:00:00.000Z
    datetime_object = datetime.strptime(datetimeString, "%y-%m-%dT%H:%M:%SZ")
    return datetime_object

Like the comment says, I am trying to convert the string "2012-08-07T00:00:00Z" to a datetime object that looks like 2012-08-07T00:00:00.000Z but I am getting an error in my console that says: "ValueError: time data '2012-08-07T00:00:00Z' does not match format '%y-%m-%dT%H:%M:%SZ'". The format seems correct to me and i'm not seeing the issue.

Thanks in advance!

datetime.strptime(datetimeString, "%Y-%m-%dT%H:%M:%SZ")

Carlo 1585
– Carlo 1585

2018-07-26 13:18:42 +00:00
Commented Jul 26, 2018 at 13:18 — Carlo 1585
– Carlo 1585, Commented Jul 26, 2018 at 13:18
could you accept my answer if you think it is correct ?

NanoPish
– NanoPish

2018-07-31 16:03:31 +00:00
Commented Jul 31, 2018 at 16:03 — NanoPish
– NanoPish, Commented Jul 31, 2018 at 16:03

Kevin · Accepted Answer · 2018-07-26 13:17:22Z

4

%y is for two-digit years. You have a four-digit year.

Try using %Y instead.

>>> from datetime import datetime
>>> datetimeString = "2012-08-07T00:00:00Z"
>>> print(datetime.strptime(datetimeString, "%Y-%m-%dT%H:%M:%SZ"))
2012-08-07 00:00:00

answered Jul 26, 2018 at 13:17

Kevin

76.5k13 gold badges141 silver badges168 bronze badges

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

1 Comment

Scott Over a year ago

Ah I knew it was something small. Thanks!

NanoPish · Accepted Answer · 2018-07-26 13:16:29Z

2

A nice way to parse your iso-8601 datetime string "2012-08-07T00:00:00Z" to a datetime object is using dateutil.

import dateutil.parser
yourdate = dateutil.parser.parse(datestring)

With strptime:

datetime.datetime.strptime( "2007-03-04T21:08:12", "%Y-%m-%dT%H:%M:%S")

Works. As an other answer said, the Y must be capitalized for strptime to work with 4 digit years.

answered Jul 26, 2018 at 13:16

NanoPish

1,5062 gold badges21 silver badges36 bronze badges

Collectives™ on Stack Overflow

Python Datetime object

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related