« first day (662 days earlier)      last day (1514 days later) » 

4:17 AM
0
Q: How to show Data using Between Dates even the date doesnt have data?

mdzkI have a table called Tax, consists of: id year paid_date amount For graph purposes, I want to get the data by PaidDate and group the data by MONTH. I have use this query: SELECT MONTH(paid_date) as month, sum(amount) as sum_amount FROM tax WHERE BETWEEN START_DATE AND END_DATE GROUP BY MON...

 

« first day (662 days earlier)      last day (1514 days later) »