Return days base on 360 calendar days
Hello everyone,
I would like to write a simple query which return me days on base of 360 calendar days for example, when i write bellow query, it returns me days on base of 365 days:
select to_date('15-feb-2018')-to_date('15-Nov-2017'), 'mid-feb' label1 from dual
union all
select to_date('15-Aug-2018')-to_date('15-Nov-2017'), 'mid-aug' label1 from dual
Results:
| Actual Result | Desire result | |
| 92 | 90 | mid-feb |
| 273 | 270 | mid-aug |
| Mid Feb | ||
| Desire Result | Actual result | |
| 17-Nov | 16 | 16 |
| 17-Dec | 30 | 31 |
| 18-Jan | 30 | 31 |
| 18-Feb | 14 | 14 |
| 90 | 92 | |
| Mid Aug | ||
| Desire Result | Actual result | |
| 17-Nov | 16 | 16 |
| 17-Dec | 30 | 31 |
| 18-Jan | 30 | 31 |
| 18-Feb | 30 | 28 |
| Mar-18 | 30 | 31 |
| Apr-18 | 30 | 30 |
| May-18 | 30 | 31 |
| Jun-18 | 30 | 30 |
| Jul-18 | 30 | 31 |
| Aug-18 | 14 | 14 |
| 270 | 273 | |
| Desire Result |