TIMEDIFF and SQLAlchemy

[Christian Démolis]

Hi,

Do you know how to do this query with sqlalchemy?

SELECT
Id,  TIMEDIFF( End, Start)
FROM
plage
WHERE
TIMEDIFF(End,Start)>=TIME('02:20:00');

In my model, Start and End are DateTime
Start = Column('Start', DateTime)
End = Column('End', DateTime)

[akm]

Try this:

from sqlalchemy import func
from sqlalchemy.sql import select

s = select( [Plage.Id,
func.timediff(Plage.Start, Plage.Start)
],
(func.timediff(Plage.Start, Plage.Start) >= func.time('02:20:00'))
)

Thanks,
--
Abdul Kader M

> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlal...@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>

[Christian Démolis]

It works!

Thx

2010/11/17 akm <akm....@gmail.com>