选择两个不同日期之间的记录

Question

I want to select records from a table that has a date between 28-02-2012 to 30-30-2012

Does any one know how to do this, please answer it

Thanks

i want data like this after run the query

proname pc1tot pc2tot  allpctot

sample1  10      12      22

Answer 1

SELECT * FROM table_name WHERE date_col BETWEEN '2012-02-28' AND '2012-03-30'

I assume this is typo- Not 2012-30-30, It is 2012-03-30