Re: [sqlalchemy] How to search a particular hour?

2010-02-18 Thread Manlio Perillo
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ning ha scritto: > Hi all, > > Anyone have any ideal how to search a particular hour. > > usually we can use datepart function in sql. > > for example > > datepart(hour, datetime) in (7,8) > > But it is not really working in sqlalchemy > > I trie

[sqlalchemy] How to search a particular hour?

2010-02-18 Thread Ning
Hi all, Anyone have any ideal how to search a particular hour. usually we can use datepart function in sql. for example datepart(hour, datetime) in (7,8) But it is not really working in sqlalchemy I tried func.datepart(func.hour, xx.c.datetime)._in((7,8)) but i got NotSupportedError: (NotS