From: Josh Berkus <josh@agliodbs.com>
To: Tomasz Myrta <jasiek@klaster.net>
To: Peter Childs <blue.dragon@blueyonder.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: Does anyone use TO_CHAR(INTERVAL)?
Date: Wed, 26 Mar 2003 08:34:31 -0800
Message-ID: <200303260834.31708.josh@agliodbs.com> (raw)
In-Reply-To: <3E817B63.2040006@klaster.net>
References: <Pine.LNX.4.44.0303260929090.5091-100000@RedDragon.Childs>
<3E817B63.2040006@klaster.net>
Tomasz, Peter,
> I already know all of these things (look at thread "Formatting
> intervals" dated on 2003-03-17). I was just thinking about intervals
> idea. Keeping time inside interval is good. Keeping months inside
> interval also looks good, but keeping both of them doesn't make sense.
> It is impossible to use these fields together without referring them to
> some real date.
However illogical the current bahavior may seem, it *is* the SQL92/99
specification, so we're keeping it.
I personally use INTERVAL heavily for calendaring applications. I got into a
discussion with Thomas Lockhart last year about how INTERVAL treats daylight
savings time -- which is seriously problematic from a calendar designer's
perspective -- and was turned down by the core team wanting to change the
behavior.
Regrettably, even though the ANSI committee made a few mistakes with
DATE/TIME, they *are* the ANSI committee and PostgreSQL as a project is very
firmly committed to standards.
--
Josh Berkus
Aglio Database Solutions
San Francisco
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: josh@agliodbs.com, jasiek@klaster.net, blue.dragon@blueyonder.co.uk
Subject: Re: Does anyone use TO_CHAR(INTERVAL)?
In-Reply-To: <200303260834.31708.josh@agliodbs.com>
* 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