MySQL Python incorrect datetime value

Question

Hi I'm gathering some info from other website with the time in all formats. MySQL datatype is 'DATATIME', I'm getting the following error.

OperationalError: (1292, "Incorrect datetime value: 'Tue, 27 Jan 2015 05:59:09 GMT' for column 'date' at row 1")

Any help on this is appreciated.

shadab.tughlaq · Accepted Answer · 2015-01-27 07:15:48Z

3

To Handle your particular error, do as follows

import datetime
your_date = "Tue, 27 Jan 2015 05:59:09"
print datetime.datetime.strptime(your_date, '%a, %d %b %Y %H:%M:%S').strftime('%Y-%m-%d %H:%M:%S')

Incase there is a finite set of websites, you need to handle the date formats individually. Please go through below link.

http://strftime.org/

answered Jan 27, 2015 at 7:15

shadab.tughlaq

4646 silver badges15 bronze badges

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

3 Comments

Sakhileti Satya Kishore Over a year ago

how GMT and +0530 is represented in the datetime.strptime() fileds after %a, %d %b %Y %H:%M:%S.. my date format is Tue, 27 Jan 2015 05:59:09 GMT and Wed, 12 Sep 2012 10:50:34 +0530

Sakhileti Satya Kishore Over a year ago

Its showing a ValueError: unconverted data remains: GMT

Sakhileti Satya Kishore Over a year ago

I got the solution for GMT, how can i represent Wed, 12 Sep 2012 10:50:34 +0530 –

sundar nataraj · Accepted Answer · 2015-01-27 07:03:28Z

2

I think The Datetime format your passing is different from MySql's .. The Mysql Dateformat is like YYYY-MM-DD HH:MM:SS

answered Jan 27, 2015 at 7:03

sundar nataraj

8,7102 gold badges36 silver badges48 bronze badges

Collectives™ on Stack Overflow

MySQL Python incorrect datetime value

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related