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"
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';