SQL*Plus (MOSC)

MOSC Banner

Return days base on 360 calendar days

edited Jun 13, 2018 3:13AM in SQL*Plus (MOSC) 4 commentsAnswered ✓

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
9290mid-feb
273270mid-aug

  

Mid Feb
Desire ResultActual result
17-Nov1616
17-Dec3031
18-Jan3031
18-Feb1414
9092

  

Mid Aug
Desire ResultActual result
17-Nov1616
17-Dec3031
18-Jan3031
18-Feb3028
Mar-183031
Apr-183030
May-183031
Jun-183030
Jul-183031
Aug-181414
270273

   

Desire Result
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center