[sqlalchemy] Re: query date field

2007-07-07 Thread Andreas Jung
--On 6. Juli 2007 23:27:30 + jose [EMAIL PROTECTED] wrote: I've got a question that I can't find the answer to. I have a table called seminars with a date field in it to hold the seminar dates. I want to query the table to find all the dates for a specific year. I tried

[sqlalchemy] Re: query date field

2007-07-07 Thread Mike Orr
On 7/6/07, Andreas Jung [EMAIL PROTECTED] wrote: --On 6. Juli 2007 23:27:30 + jose [EMAIL PROTECTED] wrote: I've got a question that I can't find the answer to. I have a table called seminars with a date field in it to hold the seminar dates. I want to query the table to find

[sqlalchemy] Re: query date field

2007-07-07 Thread Michael Bayer
heh...youve both answered correctly ...based on the databases you happen to be using (oracle, mysql). unfortanately we dont yet have a layer of function abstraction that smooths over differences like these. theres a ticket in place in trac but its awaiting a volunteer for now. On Jul 7, 5:03

[sqlalchemy] Re: query date field

2007-07-07 Thread Jose Galvez
Thanks, everyone for the pointers. Since func is not database agnostic, I think I'll make my own functions in my database module that simply use func so if I ever do switch form mysql to something else at least I'll know where to find all the stuff that needs changing Jose jose wrote: I've got