Hello!
Thanks for the pointers.
Here is the solution for MySQL :
session.query(List).filter(and_(func.DATE_FORMAT(List.expire,'%Y')
==2007 ,func.DATE_FORMAT(List.expire,"%m") == 12)).all()
On Dec 10, 6:08 pm, "Rick Morrison" <[EMAIL PROTECTED]> wrote:
> Yeah, it was a "for instance" answer, you'll need to use the correct MySql
> syntax of course.
>
> On 12/10/07, Adam B <[EMAIL PROTECTED]> wrote:
>
>
>
> > On Dec 10, 1:16 am, "Rick Morrison" <[EMAIL PROTECTED]> wrote:
> > > Any query using sql expressions is going to want to use correctly typed
> > data
> > > -- you're trying to query a date column with a string value. The LIKE
> > > operator is for string data.
>
> > > I'm not up on my mssql date expressions, but the answer is going to
> > resemble
> > > something like this:
>
> > > .........filter(and_(func.datepart('year', List.expire) == 2007,
> > > func.datepart('month', List.expire) == the_month_number))
>
> > Ok, isnt this mssql specifik? I only find datepart in various
> > VB / .net documentation/solutions.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
