Thanks guys, Appreciate the help. Kinda makes sense now ;-)
Jeff ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Benjamin Pflugmann" <[EMAIL PROTECTED]>; "Jeff" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 9:32 AM Subject: Re: Syntax confusion > At 0:23 +0100 3/6/03, Benjamin Pflugmann wrote: > >On Wed 2003-03-05 at 17:12:23 -0600, [EMAIL PROTECTED] wrote: > >[...] > >> BA_DATE >= '2003-02-25 00:00:00' AND BA_DATE <= '2003-02-25 23:59:59' > >> > >> or > >> > >> TO_DAYS(FROM_DAYS(BA_DATE)) = '2003-02-25' > > > >Hm. You mean FROM_DAYS(TO_DAYS(BA_DATE)), don't you? BA_DATE is a > >timestamp, not a number of days. > > Of course. Thanks. > > > > >Aside from that, it prevents use of indexes, which is always bad. :-) > >How about > > > > BA_DATE LIKE '2003-02-25%' instead? > > That'd work, too. > > > > > > >HTH, > > > > Benjamin. > > > >-- > >[EMAIL PROTECTED] > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
