Android retrive current month data from SQLite table

SELECT * FROM DATABASE_TABLE
    WHERE strftime('%Y-%m-%d',DATE) >= date('now','-6 days') AND 
    strftime('%Y-%m-%d',DATE)<=date('now') order by DATE

Note: 

DATABASE_TABLE = table name

DATE  = column name  (date field)