[EMAIL PROTECTED] wrote:

> I need select all items, where create_date = 2008 (or anything else
> year ... )
>
> Is this the right way (but this example don`t work :( ) ?
>
> data = Table.query().filter(func.year(Table.c.create_date) == 2008)
>
> Thanks ..

You might want to try passing in a datetime.date instance, rather
than an integer.  If that doesn't work, you could query for anything
created between the first and last days of the year.

--
Jonathan LaCour
http://cleverdevil.org


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"SQLElixir" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlelixir?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to