List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 5 2003 11:32pm
Subject:Re: Syntax confusion
View as plain text  
At 0:23 +0100 3/6/03, Benjamin Pflugmann wrote:
>On Wed 2003-03-05 at 17:12:23 -0600, paul@stripped 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.
>
>--
>benjamin-mysql@stripped

Thread
Syntax confusionJeff5 Mar
  • Re: Syntax confusionPaul DuBois5 Mar
  • Re: Syntax confusionJeff6 Mar
    • Re: Syntax confusionPaul DuBois6 Mar
      • Re: Syntax confusionBenjamin Pflugmann6 Mar
        • Re: Syntax confusionPaul DuBois6 Mar
  • Re: Syntax confusionJeff6 Mar