I had problems loading TIMESTAMP values from my
database and found out that the problem comes from
invalid parsing of the timestamp value. In MySQL
versions 4.1 or higher (perhaps some other versions as
well) the timestamp format has shifted from yyyymmdd
Here's my solution to the problem. A change to times.py.
It should be incorporated to select the correct parsing
method depending on mysql version used.
s = s + "0"*(14-len(s)) # padding parts = map(int, filter(None, (s[:4],s[4:6],s[6:8], s[8:10],s[10:12],s[12:14])))
s = s + "0"*(19-len(s)) # padding parts = map(int, filter(None, (s[:4],s[5:7],s[8:10], s[11:13],s[14:16],s[17:19])))
/Simon at Hedberg net
Log in to post a comment.