Donate

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

Donate

Popular Posts From This Blog

WPF CRUD Application Using DataGrid, MVVM Pattern, Entity Framework, And C#.NET

TypeScript Error Or Bug: The term 'tsc' is not recognized as the name of a cmdlet, function, script file, or operable program.

Invalid nested tag div found, expected closing tag input