MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:sureshkumarilu Date:February 1 2010 2:25pm
Subject:Re: Selecting Dates
View as plain text  
What is the datatype of the column order_date. Give the full form of the date for the between condition.

Suresh Kuna
------Original Message------
From: ML
To: mysql@stripped
Subject: Selecting Dates
Sent: Feb 1, 2010 7:05 AM

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;


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

Neither of these work.

What am I missing?


MySQL General Mailing List
For list archives:
To unsubscribe:

Sent from BlackBerry® on Airtel
Selecting DatesML1 Feb
  • Re: Selecting DatesLucky Wijaya1 Feb
  • Re: Selecting DatesPaul DuBois4 Feb
Re: Selecting Datessureshkumarilu1 Feb
Re: Selecting DatesJim Lyons1 Feb
  • Re: Selecting DatesML1 Feb