Re: interval output format available that removes ambiguity ? - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: interval output format available that removes ambiguity ?
Date
Msg-id 20040505162359.A647@hermes.hilbert.loc
Whole thread Raw
In response to Re: interval output format available that removes ambiguity ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom,

> Just subtract the two timestamps (or dates) instead of using age().
> Then you get an interval that has no month component.
*That* was what I was looking for. Thanks !

> He didn't say that.  He said that when the system *must* convert a
> month-based interval to days and it has no date reference for it,
> it uses 30 days.  Something like "now() + '1 month'::interval"
> will do the "right thing".  This IMHO is the main application of
> intervals with month components ...
I knew PostgreSQL would do the Right Thing(tm) where possible
and assume reasonable defaults where ambiguity exists. I just
didn't know how to tell it to return the right version of the
Right Thing.

As usual, sage advice.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Mail delays (was Re: [Fwd: help building datetime from varchars])
Next
From: Bricklen
Date:
Subject: Re: Postgres to oracle data migration