pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruno Wolff III <bruno@wolff.to>
To: Tomasz Myrta <jasiek@klaster.net>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Does anyone use TO_CHAR(INTERVAL)?
Date: Tue, 25 Mar 2003 22:43:56 -0600
Message-ID: <20030326044356.GA18525@wolff.to> (raw)
In-Reply-To: <3E80AD07.5000005@klaster.net>
References: <200303250931.27351.josh@agliodbs.com>
	<3E80AD07.5000005@klaster.net>

On Tue, Mar 25, 2003 at 20:24:55 +0100,
  Tomasz Myrta <jasiek@klaster.net> wrote:
> Uz.ytkownik Josh Berkus napisa?:
> 
> It looks it could be useful to display how much time is left for
> scheduling cases, but as I wrote few threads ago - displaying intervals
> longer than one month is useless without specific date.

That isn't true. Intervals have two parts. One is time difference in
fixed time and the other is a difference in months. You could display
both parts when they are both nonzero.

I haven't found the documenation too specific on which part gets added
first (and this does make a difference in some cases).




view thread (8+ messages)  latest in thread

Message-ID: <20030326044356.GA18525@wolff.to>
Permalink:  ../20030326044356.GA18525@wolff.to/
Also on:    postgresql.org/message-id/20030326044356.GA18525@wolff.to

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: bruno@wolff.to, jasiek@klaster.net, josh@agliodbs.com
  Subject: Re: Does anyone use TO_CHAR(INTERVAL)?
  In-Reply-To: <20030326044356.GA18525@wolff.to>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox