> Hi Warwick, > > On 30/08/2013 14:38, Warwick Prince wrote: >> I'm sure there is a better way, but you could always filter using a >> date/time and supply the date part as well (i.e. today) so that you are >> comparing datetime to datetime. (Something like: select all rows where the >> datetime is between 2013-08-30 06:00:00 and 2013-08-30 11:00:00) :-) > > Thanks for your suggestion, this could do the trick. > > However my rows are split over a lot of days and if I follow your advice I'll > end with a lot of "between 2013-08-30 06:00:00 and 2013-08-30 11:00:00" (one > for each day). This will certainly work as expected, but I'm looking for a > more efficient way of doing this. > > > Thanks. > -- > Laurent Meunier <laur...@deltalima.net> > Ahh - I see. Oh well, I'm sure someone with infinitely better SQL skills with chime in shortly. :-)
Warwick > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.