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
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 order_date ='2010-01-01
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 BETWEEN='2010-01-01' AND '2010-01-30
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
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 seem
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 mistake on