Wednesday, July 13, 2011

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;  

0 comments:

Post a Comment