Re: convert interval info into days

On Fri, Aug 22, 2003 at 13:00:57 -0400,
"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> wrote:
> Howdy:
>
> I want to convert all of this into days, but
> I don't think I can use 'to_char' because
> I get things like this:

Converting intervals to days is a problem because months are treated as
having 30 days if you try to extract the number of seconds from the
interval (which could then be converted to days). If you have a base
date the interval is relative to, then I think you can get what you
want by extract the epoch from (base_date + interval) - base_date and
then divide by 24*60*60.