I need to take the difference of two dates, for example 03/16/2013 to 07/16/2014. If I do
select extract('Month' from age(data1, data2))
What will return is a result 4
, since it informs that the difference enters the date is 1 year of 4 months.
But what I need is total in months, ie,% months of difference. Is there any way?