CODEWITHSUNDEEP
pythondatetimeutcrfc3339
NIH
NIH

Reputation: 161

Convert UTC time to python datetime

I have numerous UTC time stamps in the following format: 2012-04-30T23:08:56+00:00 I want to convert them to python datetime objects but am having trouble.

My code:

for time in data:
    pythondata[i]=datetime.strptime(time,"%y-%m-%dT%H:%M:%S+00:00")

I get the following error:

ValueError: time data '2012-03-01T00:05:55+00:00' does not match format '%y-%m-%dT%H:%M:%S+00:00'

It looks like I have the proper format, so why doesn't this work?

Upvotes: 2

Views: 13026

Answers (2)

DmitrySemenov
DmitrySemenov

Reputation: 10305

I highly recommend python-dateutil library, it allows conversion of multiple datetime formats from raw strings into datetime objects with/without timezone set

>>> from dateutil.parser import parse
>>> parse('2012-04-30T23:08:56+00:00')

datetime.datetime(2012, 4, 30, 23, 8, 56, tzinfo=tzutc())

Upvotes: 0

Jon Gauthier
Jon Gauthier

Reputation: 25572

Change the year marker in your time format string to %Y:

time = '2012-03-01T00:05:55+00:00'
datetime.strptime(time, "%Y-%m-%dT%H:%M:%S+00:00")
# => datetime.datetime(2012, 3, 1, 0, 5, 55)

See strftime() and strptime() behavior.

Upvotes: 12

Related Questions