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 '
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
:
> 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:
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
__
From: ML
To: mysql@lists.mysql.com
Sent: Mon, February 1, 2010 8:35:01 AM
Subject: Selecting Dates
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 BETWEE
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;
or
SELECT * FROM orders WHERE ord
