drupal 7 - Mysql query to check nodes created in last 3 month -

i want query table node in want check records created in last 3 months. created field in table data type timestamp tried

select * node created >= date_format(curdate(), '%y-%m-01') interval -3 month 

and

select count(*),date_add((date_format(from_unixtime(created), '%e %b %y')),interval -3 month) daterange node 

but both not working

the following simplest method date operations:

select * node created >= now() - interval 3 month;