From: Tomasz Myrta <jasiek@klaster.net>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Does anyone use TO_CHAR(INTERVAL)?
Date: Tue, 25 Mar 2003 20:24:55 +0100
Message-ID: <3E80AD07.5000005@klaster.net> (raw)
In-Reply-To: <200303250931.27351.josh@agliodbs.com>
References: <200303250931.27351.josh@agliodbs.com>
Uz.ytkownik Josh Berkus napisa?:
> Folks,
>
> We're discussing the behavior of the current "to_char(interval)" function on
> HACKERS. Does anyone on this list use the current behavior? Please speak
> up, as we're trying to figure out what backward compatibility needs to be
> maintained.
>
> PLEASE NOTE: This is only to_char() for INTERVAL values, NOT for dates,
> timestamp, or numeric!
In my projects intervals are always related to some dates when
displaying them, so I use to_char(date+interval).
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.
Anyway, maybe it should be left for future use, but without patterns
related to date, or maybe with DDD only?
Regards,
Tomasz Myrta
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: jasiek@klaster.net, josh@agliodbs.com
Subject: Re: Does anyone use TO_CHAR(INTERVAL)?
In-Reply-To: <3E80AD07.5000005@klaster.net>
* 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