I assume youre using SQLite ? the other database adapters use datetime objects and date/time columns in the database, so string representations shouldnt matter.
Anyway, at the moment you can make your own date type, probably as a subclass to the SQLite date types defined in sqlalchemy.database.sqlite which do something different with the date parsing...see the example in "Creating your own types" in the "types" section of the docs. You can specify instances of your new type class just like any other type object when defining table metadata. It might be a good idea for me to add a new base type called "EncodedDate" or something like that which handles the "string-based date" idea more easily, allowing format strings to be specified. Nicholas Wieland wrote: > Hi *, > I'm having a problem setting client encoding for a simple select_by > query, and actually my tests fail because a datetime is represented > with a different encoding, '1978-10-12 00:00:00.00' instead of > '1978-10-12 00:00:00,00' (look at the last ,). > How can I force the client to use the encoding or locale I want ? > > TIA, > ngw > > p.s. SqlAlchemy is a wonderful product, thank you ! > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log > files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642 > _______________________________________________ > Sqlalchemy-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users > ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Sqlalchemy-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
