[DB-SIG] Dealing with bogus date in MySql

Mark Rages markrages at gmail.com
Fri May 6 00:28:16 CEST 2005


I hope this list can help me.

I have a MySQL table with some dates, like this:
mysql> select MIN(change_date),MAX(change_date) from status_history;
| MIN(change_date)    | MAX(change_date)    |
| 2000-11-14 74:17:72 | 2005-05-05 17:17:43 |
1 row in set (0.34 sec)

Notice that first date is kind of funky; most days don't have 72 hours.

I'm trying to get the information out with MySQLdb:
self.cur.execute("select MIN(change_date),MAX(change_date) from status_history")
print self.cur.fetchone()
which gives:

(None, <DateTime object for '2005-05-05 17:17:43.00' at b7f90c98>)

Is there some way I can get the date with MySQLdb?  "None" just isn't
helpful for my application.

markrages at gmail
You think that it is a secret, but it never has been one.
  - fortune cookie

More information about the DB-SIG mailing list