Hi All, I need to construct the following query: select ADDDATE(start,INTERVAL rt_daily_days DAY) from _event where repeat_type = 1;
and I have difficulties in dealing with the following statement: INTERVAL rt_daily_days DAY, how can I do this using sqlalchemy func interfaces? func.ADDATE(Event.start, ??? Event.rt_daily_days ???) the following func.ADDATE(Event.start, func.INTERVAL(Event.rt_daily_days,'DAY')) generates INTERVAL(rt_daily_days,'DAY') what does not work for mysql Any ideas? Alex --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---