Author lemburg
Recipients brandon, lemburg
Date 2014-05-24.14:05:33
SpamBayes Score -1.0
Marked as misclassified Yes
Message-id <5380A720.1030003@egenix.com>
In-reply-to <1400939714.27.0.921682878277.issue21570@psf.upfronthosting.co.za>
Content
On 24.05.2014 15:55, Brandon wrote:
> 
> Observe the following code:
> 
> import MySQLdb, MySQLdb.cursors, datetime
> """ ... mysqlCursor is a cursor object from a connection to database from the MySQLdb module ... """
> mysqlCursor.execute("SELECT NOW()")
> timeRow = mysqlCursor.fetchall()
> currentDateTime = datetime.datetime.strptime(timeRow[0]["NOW()"], "%Y-%m-%d %H:%M:%S")
> 
> I get the following error:
> 
> TypeError: must be string, not datetime.datetime
> 
> HOWEVER, when I cast timeRow[0]["NOW()"] to a string like: str(timeRow[0]["NOW()"]) , it works fine.
> 
> For whatever reason the Python interpreter seems to interpret the string from the row of the MySQLdb cursor result as a datetime.datetime object. I have no explanation for this, besides it looking like a date time in the format of YYYY-mm-dd HH:MM:SS. 

It's likely that MySQLdb returns the datetime value as Python
datetime.datetime object, so not really surprising that you get
a TypeError.
History
Date User Action Args
2014-05-24 14:05:34lemburgsetrecipients: + lemburg, brandon
2014-05-24 14:05:33lemburglinkissue21570 messages
2014-05-24 14:05:33lemburgcreate