How about
SELECT * FROM table_name WHERE strftime('%m', date_column) = '04'
Date And Time Functions
SELECT * FROM `table name` WHERE strftime('%m', `date column`) = '04'
sqlite date&time functions