From: ML
Date: February 1 2010 1:35am
Subject: Selecting Dates
List-Archive: http://lists.mysql.com/mysql/220523
Message-Id: <7A4D2D72-6DAD-4D55-BCB4-1749F6B980DF@mailnewsrss.com>
MIME-Version: 1.0 (Apple Message framework v1078)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

Hi All,

Switching from Oracle to MySQL, I seem to be having some difficulty =
selecting dates using between or even where >=3D and <=3D like:

SELECT * FROM orders WHERE order_date BETWEEN=3D'2010-01-01' AND =
'2010-01-30' ORDER BY order_date;

or

SELECT * FROM orders WHERE order_date =3D>'2010-01-01' AND <=3D =
'2010-01-30' ORDER BY order_date;

Neither of these work.

What am I missing?

-ML