Quoth Michael Bayer <mike...@zzzcomputing.com>: > > Assuming these columns are ultimately CHAR or VARCHAR on the mysql > side, build your own Date type using TypeDecorator in conjunction with > the String type. MySQLdb's date/time functionality only takes effect > for columns that are of the DATE, TIME or DATETIME columns.
No, as I said, these are DATE files on the MySQL side. Which is exactly the problem. If they were CHAR, I wouldn't have a problem :) > On Feb 1, 2009, at 2:58 PM, 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. > > > > --RDM --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---