My SQlite database in my app stores the date in the format of yyyy-MM-dd HH:mm:ss
. I want to query a transaction that happened on a certain month of a year but my code is not working :
x
SELECT COUNT(id_sale) AS total_transactions,sold_to,
strftime('%m', sale_date) AS month,
strftime('%Y', sale_date) AS year,
sale_date FROM sales WHERE month=5 AND year=2015
Advertisement
Answer
After some research I discovered that for some reason I had to do some casting for it to work.
SELECT COUNT(id_sale) AS total_transactions,sold_to,
CAST(strftime('%m', sale_date) AS INTEGER) month,
CAST(strftime('%Y', sale_date) AS INTEGER) year,
sale_date FROM sales WHERE month=5