List:General Discussion« Previous MessageNext Message »
From:ML Date:February 1 2010 3:13pm
Subject:Re: Selecting Dates
View as plain text  
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 my part.

-ML
Thread
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