Re: [sqlalchemy] sqlite filter datetime

On 6/4/15 3:22 PM, mdob wrote: The database is OK. I found out that calling func.datetime on value in declarative filtering fixed query and returned expected result. | query =query.filter(Invoice.InvoiceDate==func.datetime(datetime.datetime(2007,1,1))) | echo: | SELECT "Invoice"."InvoiceId

Re: [sqlalchemy] sqlite filter datetime

The database is OK. I found out that calling func.datetime on value in declarative filtering fixed query and returned expected result. query = query.filter(Invoice.InvoiceDate == func.datetime(datetime.datetime( 2007, 1, 1))) echo: SELECT "Invoice"."InvoiceId" AS "Invoice_InvoiceId", "Invoice"."

Re: [sqlalchemy] sqlite filter datetime

On 6/4/15 11:57 AM, mdob wrote: Hi, It seems I have different result when filtering sqlite database on datetime column. I don't get any results when filtering declarative way | Invoice.InvoiceDate==datetime.datetime(2007,01,01) | same when hen executing raw query with engine.execute | 'sel

[sqlalchemy] sqlite filter datetime

Hi, It seems I have different result when filtering sqlite database on datetime column. I don't get any results when filtering declarative way Invoice.InvoiceDate == datetime.datetime(2007, 01, 01) same when hen executing raw query with engine.execute 'select * from Invoice where InvoiceDate =