[sqlalchemy] Re: extract the WEEK off a timestamp across multiple database backends

2016-04-02 Thread Jonathan Vanasco
I forgot to add... in the interim I checked the session.connection().dialect and used a different filter for sqlite -- 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 t

[sqlalchemy] extract the WEEK off a timestamp across multiple database backends

2016-04-02 Thread Jonathan Vanasco
I need to extract the week of the year across multiple databases (this needs to work on at-least sqlite and postgres, though mysql would be good too.) the problem? this operation isn't standard: sqlite: select strftime('%W', cast(timestamp_event as text)) from table_a; postgres: selec