I recently upgraded to dm 0.9.11 and do_sqlite3 0.9.12 on snow leopard and started experiencing some issues with the format of stored DateTime and Time values. Previously they were getting stored in sqlite's format: 'YYYY-MM-DD HH:MM:SS', but they began appearing in ISO8601 format: 'YYY-MM-DDThh:mm:ss.sTZD', which can break a lot of stuff, obviously :(
I'm really unfamiliar with the internals of mapping types to DB types in DataMapper, but it strikes me that this is the default string representation for DateTime/Time and I'm wondering if somewhere in do_sqlite3 or datamapper the date is being inserted as a string object using its string representation instead of being treated like a date. Does anyone know if this is a correct guess? If it is, is the best approach to override to_s on DateTime/Time? Or, is there a way to set this globally for DataMapper? Am I completely off track? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DataMapper" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/datamapper?hl=en -~----------~----~----~----~------~----~------~--~---
