Month_Between function in oracle is used for calculating Year, Month & Days

select    trunc (months_between (end_date, start_date) / 12)
|| ‘ Years ‘ 

       || mod (trunc (months_between (end_date, start_date)), 12)
       || ‘ Months ‘
       || (  to_date (end_date)
           – add_months (start_date,
                         trunc (months_between (end_date, start_date))
                        )
          )
       || ‘ Days’
  from dual;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: