rdmur...@bitdance.com wrote: > I have an existing MySQL database (that I do not control) with schema > fields defined using the 'Date' type. The values that occur in these > fields often have a 'day' of '00', and sometimes a month of '00', and > sometimes the field's value is 0000-00-00. The zeros are used to indicate > "don't know" (or, sometimes, "don't care"). > > Since '00' is invalid for the fields in a Python DateTime, it seems as though > I can't actually use DateTime to manage these values. My application > should be able to use them as strings, but how do I arrange to do that? > The conversion to DateTime is presumably taking place at the DBAPI level.
Check out the MySQLdb docs for the 'conv' type mapping option to connect(). I think you should be able to override the default datetime with your own convert that falls back to a string or whatever you'd like it to do. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
