hamsa_mohan

 Profile Answers by hamsa_mohan 

• Feb 18th, 2009

 

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

Ravi Ranjan Kumar

 Profile Answers by Ravi Ranjan Kumar 

• Feb 23rd, 2009

 

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