On Jan 31, 2010, at 7:35 PM, ML wrote:
> Hi All,
>
> Switching from Oracle to MySQL, I seem to be having some difficulty selecting dates
> using between or even where >= and <= like:
>
> SELECT * FROM orders WHERE order_date BETWEEN='2010-01-01' AND '2010-01-30' ORDER BY
> order_date;
No "=" after BETWEEN.
>
> or
>
> SELECT * FROM orders WHERE order_date =>'2010-01-01' AND <= '2010-01-30' ORDER
> BY order_date;
Need "order_date <=", not just "<=".
>
> Neither of these work.
>
> What am I missing?
>
> -ML
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
