Re: DATETIME columns and indexing

2005-11-22 Thread SGreen
"Jonathan Mangin" <[EMAIL PROTECTED]> wrote on 11/22/2005 10:37:00 AM: > (I used to have separate date/time cols. in all tables > but changed them to datetime and buggered up some stuff. > Now I'm trying to find the best way to fix this.) > > If I have an indexed datetime column (`date`), and sa

DATETIME columns and indexing

2005-11-22 Thread Jonathan Mangin
(I used to have separate date/time cols. in all tables but changed them to datetime and buggered up some stuff. Now I'm trying to find the best way to fix this.) If I have an indexed datetime column (`date`), and say: select date, from table1 where date between '2005-08-01' and '200