SQLite SELECT date for a specific month SQLite SELECT date for a specific month sqlite sqlite

SQLite SELECT date for a specific month


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