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 "="
Jim,
> Shouldn't it be:
> SELECT * FROM orders WHERE order_date >= '2010-01-01' AND order_date <=
> '2010-01-30' ORDER BY order_date;
>
> ?
>
> change the "=>" and repeat the column_name. Datetime should be datetime or
> timestamp;
Spot on. Thank you for the clarification, obviously a syntax
Shouldn't it be:
SELECT * FROM orders WHERE order_date >= '2010-01-01' AND order_date <=
'2010-01-30' ORDER BY order_date;
?
change the "=>" and repeat the column_name. Datetime should be datetime or
timestamp;
On Mon, Feb 1, 2010 at 8:25 AM, wrote:
> Hi
> What is the datatype of the column o
Hi
What is the datatype of the column order_date. Give the full form of the date
for the between condition.
Thanks
Suresh Kuna
MySQL DBA
--Original Message--
From: ML
To: mysql@lists.mysql.com
Subject: Selecting Dates
Sent: Feb 1, 2010 7:05 AM
Hi All,
Switching from Oracle to MySQL, I s
Just trying to help.
SELECT * FROM orders WHERE order_date BETWEEN '2010-01-01' AND
'2010-01-30' ORDER BY order_date;
or
SELECT * FROM orders
WHERE order_date >= '2010-01-01' AND <= '2010-01-30' ORDER BY
order_date;
From: ML
To: mysql@lists.mysql.com
Sen
