Re: filtering by datetime elements

On Tue, May 27, 2008 at 12:14 PM, Michael Bayer
<mike_mp <at> zzzcomputing.com> wrote:
>
>
> On May 27, 2008, at 10:56 AM, Roger Demetrescu wrote:
>
>>
>> On Sat, May 17, 2008 at 12:17 PM,  <az <at> svilendobrev.com> wrote:
>>
>>> wishlist suggestion: how about type-related attributes on columns,
>>> using which will autogenerate some expr off that column?
>>> e.g. select( mytable.c.mydate.year == '1998') to automagicaly yield
>>> something like func.substr(mytable.c.mydate,1,4)) == '1998'
>>> (supposing the type of mydate stores datetime as yyyymmdd string)
>>
>> That sounds interesting...
>>
>> +1 on that...  :)
>>
>>
>> Michael, is that feasible / desirable for SA 0.5 ?
>
> not really since its fairly arbitrary and redundant against using
> func.XXX().

<SNIP>

Ok... thanks for the answer Michael...

Cheers,

Roger

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to sqlalchemy <at> googlegroups.com
To unsubscribe from this group, send email to sqlalchemy-unsubscribe <at> googlegroups.com
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---