[DB-SIG] Dealing with bogus date in MySql

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


Hi,

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.conn=MySQLdb.connect(db=db,user=dbuser,host=dbhost,passwd=dbpass)
self.cur=self.conn.cursor()
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.

Regards,
Mark
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