On Aug 7, 2012, at 11:55 AM, Steve Atkins wrote:
> Something like this?
>
> select 12 * extract(year from ?) + extract(month from ?) + extract(epoch from
> ? - date_trunc('month', ?)) / 2592000
>
> Ugly, but likely closer to accurate. You can't get actually accurate, of
> course, as you don't
On Aug 7, 2012, at 8:41 AM, Aram Fingal wrote:
> I have a field which contains an interval value and I sometimes need to
> represent the full interval (not a part) as a decimal number of months. For
> example, "5 years 6 mons 3 days" as "66.1 months". I've been trying to
> figure out how to
I have a field which contains an interval value and I sometimes need to
represent the full interval (not a part) as a decimal number of months. For
example, "5 years 6 mons 3 days" as "66.1 months". I've been trying to figure
out how to do this and haven't found a definitive answer.
The fol
