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 |