I'm working on a holiday scheduling app and I was wondering that if a person wants his holiday for example 10 days.
id uid data1 data2 ore tip_concediu ts 7 244 2013-01-25 2013-02-05 3 2 2013-01-25 16:08:35
How would it be possible that I could track the holiday for each month ?
January - 6 days
February - 5 days
In this case, January has 31 days, I would like to group the days into months, in January I should have 6 days and the remaining in February, is this possible from a query?
Thanks in advance