Re: [sqlalchemy] sqlite problem with datetime format YYYY-MM-DDTHH:mm:ss

Thanks a lot!! On Thursday, September 3, 2015 at 5:18:29 PM UTC+2, Simon King wrote: > > That's fine - the "regexp" argument is only used when interpreting the > data that comes back from sqlite - it doesn't depend on you actually > creating the table from SQLAlchemy. > > It does require that

Re: [sqlalchemy] sqlite problem with datetime format YYYY-MM-DDTHH:mm:ss

Hi Simone, thank you for your reply. Unfortunately I don't create the table so I don't define the table, I only load it from the DB. I hope I intended your suggestion correctly. Thanks again. On Thursday, September 3, 2015 at 3:54:45 PM UTC+2, Simon King wrote: > > On Thu, Sep 3, 2015 at 1:05

Re: [sqlalchemy] sqlite problem with datetime format YYYY-MM-DDTHH:mm:ss

On Thu, Sep 3, 2015 at 1:05 PM, Massi wrote: > Hi everyone, > > I'm trying to use sqlalchemy (0.9.10) to read a sqlite table which contains > some datetime columns. As the title says these column are given in the > format -MM-DDTHH:mm:ss (I did not create the table). When I

[sqlalchemy] sqlite problem with datetime format YYYY-MM-DDTHH:mm:ss

Hi everyone, I'm trying to use sqlalchemy (0.9.10) to read a sqlite table which contains some datetime columns. As the title says these column are given in the format -MM-DDTHH:mm:ss (I did not create the table). When I execute the query, it succeeds, but when I try to convert the rows to