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 sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
