SQLite - Select Date for a specific month - Extract month from a date to check that in a where clause

Use strftime() - Here as an example all dates with the month July (number 7) are selected.

SELECT * FROM tablename WHERE strftime('%m', datecolumn) = '07'

tablename is your table name and datecolumn is your column where your date is saved.

If you want to extract the Month for the current date, then use the following SQL query:

SELECT strftime('%m','now')

More about strftime()