ast wrote: > > Hello > > M trying to use to_char function which works on postgres but gives > error on mysql. > > My code is > > import sqlalchemy > from sqlalchemy import * > > engine = sqlalchemy.create_engine("mysql://root:r...@localhost:3306/ > newdb",echo=True) > meta = MetaData(engine) > t1 = Table("Table1",meta) > id = Column("id",t1) > sel = select() > c1 = func.to_char(id,'999') > sel.append_column(c1) > sel.append_from(t1) > > res = engine.execute(sel) > > If i change the engine to postgres it works fine. But thn how come i > make it neutral.
use cast(). --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---