Yes, obviously :) But I meant in general for any python type -> native postgresql type; I guess there are not that many really I could just handle all the cases I want to use..
On Fri, Sep 20, 2013 at 5:05 PM, Michael Bayer <mike...@zzzcomputing.com>wrote: > > On Sep 20, 2013, at 10:35 AM, Philip Scott <safetyfirstp...@gmail.com> > wrote: > > > > > Without actually querying the DB or enumerating the types and their > conversions myself which seems a bit naff; psycopg2.extensions.adapt > almost does it but not quite (e.g. you get "'2013-09-10'::date" when CAST() > gives you "2013-09-10"). Any ideas? It's not vital, I don't do much up > dating of these guys really so I have it doing a supplemental SQL query > like the one above for every update/insert :) > > date to string without SQL access....how about strftime() ? > > > http://docs.python.org/2/library/datetime.html#strftime-strptime-behavior > > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.