Inserting python datetime into the mysql table

Question

I have a Python date like

2013-04-04T18:56:21Z

I want to store this into my mysql database .

I tried like

self.start_at = datetime.strptime(self.start_at.split(".")[0], "%Y-%m-%dT%H:%M:%S")

But i am getting an error

ValueError: unconverted data remains: Z

PLease tell me how to convert the above date in mysql acceptable format .

ChrisGuest · Accepted Answer · 2013-04-18 05:13:15Z

1

In this instance this will work.

>>> from datetime import datetime
>>> start_at = '2013-04-04T18:56:21Z'
>>> datetime.strptime(start_at , "%Y-%m-%dT%H:%M:%SZ")
datetime.datetime(2013, 4, 4, 18, 56, 21)

Are the T & Z characters always in your date format or do they every change? If the is some variation in these seperator characters, you should do something like this:

>>> from datetime import datetime
>>> start_at = '2013-04-04T18:56:21Z'
>>> datetime.strptime(start_at[0:10] + ' ' + start_at[11:19], "%Y-%m-%d %H:%M:%S")
datetime.datetime(2013, 4, 4, 18, 56, 21)

edited Apr 18, 2013 at 5:13

answered Apr 18, 2013 at 4:57

ChrisGuest

3,6284 gold badges37 silver badges56 bronze badges

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

2 Comments

burning Over a year ago

I am getting this TypeError: 'datetime.datetime' object has no attribute 'getitem'

ChrisGuest Over a year ago

I've amended the code, to clarify the assumptions involved. This should now run as a standalone python 2.* example.

Collectives™ on Stack Overflow

Inserting python datetime into the mysql table

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related