Re: date time function

"John D. Burger" <john(at)mitre(dot)org> writes:
> Why do the first and third intervals print out differently?

The underlying storage is months, days, and seconds --- "1 year"
is the same as "12 months", but not the same as "365 days".
IIRC plain timestamp subtraction produces an interval with days and
seconds but the month part is always 0. You can use justify_days
to convert days to months (at an assumed 30 days/month). I'm not
sure exactly what age() does but it's probably producing a value
that has nonzero months to start with.

regards, tom lane