MySQL Date Range Query (Using Logical Operators)
Here's another version using logical operators in MySQL.
1: select date_format(date_purchased,'%m/%d/%Y')as dates, 2: url from dbcommerce.tblproducts 3: where date_format(date_purchased,'%m/%d/%Y') >= '04/30/2011' 4: and date_format(date_purchased,'%m/%d/%Y') <= '05/30/2011' 5: order by date_purchased asc;
Comments
Post a Comment