On Fri, Dec 3, 2010 at 4:08 AM, jo <jose.soa...@sferacarta.com> wrote: > Hi all, > > I'm trying to write a GROUP BY query grouped by a function (to_char) using a > variable format, which could be 'yy' or 'yyyy' > as in: > > sql=session.query( > func.to_char(Prestazione.c.data,format), > func.sum(Prestazione.c.quantita).label('quantita'), > func.sum(Prestazione.c.importo).label('importo') > ) > sql=sql.filter(Verifica.c.codice == Tariffa.c.codice) > sql=sql.filter(Prestazione.c.id_tariffa == Tariffa.c.id) > sql=sql.group_by(Verifica.c.codice, func.to_char(Prestazione.c.data,format))
Have you tried using the same func result in both places, i.e.: to_char = func.to_char(Prestazione.c.data,format) sql=session.query( to_char, func.sum(Prestazione.c.quantita).label('quantita'), func.sum(Prestazione.c.importo).label('importo') ) sql=sql.filter(Verifica.c.codice == Tariffa.c.codice) sql=sql.filter(Prestazione.c.id_tariffa == Tariffa.c.id) sql=sql.group_by(Verifica.c.codice, to_char) -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.