I saved my data In SQLite Database. I saved my date in database as DATETIME datatype.

I wish to retrive just the data of specific month from the SQLite databse.

I attempt the below query to retrive data, but it wasn't helpful. It provides me with data but it wasn't the particular month.

SELECT coulumn_name FROM table_name WHERE column_name Between "MM-DD-YYYY" AND "MM-DD-YYYY"

Help Me...

Make use of a function retrieve just the month from the date

SELECT strftime('%m', date(column_name)) FROM table;

In my opinion this is actually the function, but I am not too sure.

This really is most likely not optimal, but you could utilize:

select column_name from table_name where strftime('%Y-%m', column_name) = '2011-05';