How will you fetch the records of last week and last month?

Ravi Ranjan Kumar

 Profile Answers by Ravi Ranjan Kumar Questions by Ravi Ranjan Kumar

• Feb 23rd, 2009

Select * from state where stateTime  > date_sub(curdate(),interval 7 day);

hamsa_mohan

 Profile Answers by hamsa_mohan Questions by hamsa_mohan

• Feb 18th, 2009

Select * from table1 where date_a  > date_sub(current_date,inteval 7 day);

Answer Question  Select Best Answer