How to read microsecond-precision mysql datetime fields with python

Question

I'm using python's MySQLdb to fetch rows from a MySQL 5.6.7 db, that supports microsecond precision datetime columns. When I read a row with MySQLdb I get "None" for the time field. Is there are way to read such time fields with python?

Pablo · Accepted Answer · 2013-09-17 21:54:39Z

2

Unfortunately, neither MySQLdb version 1.2.4b4 nor 1.2.4c1 have fixed the issue yet. It works, though, if you apply the patches of the mailinglist to the times.py file:

to the function DateTime_or_None
to the functions TimeDelta_or_None and Time_or_None

edited Sep 17, 2013 at 21:54

answered Sep 17, 2013 at 21:42

Pablo

771 silver badge7 bronze badges

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

Comments

farcepest · Accepted Answer · 2012-11-08 23:16:06Z

1

MySQLdb-1.2.4 (to be released within the next week) and the current release candidate has support for MySQL-5.5 and newer and should solve your problem. Please try 1.2.4c1 from PyPi (pip install MySQL-python)

answered Nov 8, 2012 at 23:16

farcepest

1456 bronze badges

Collectives™ on Stack Overflow

How to read microsecond-precision mysql datetime fields with python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related