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
-~----------~----~----~----~------~----~------~--~---
