Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f76Mql670929 for ; Mon, 6 Aug 2001 18:52:47 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.1) with HTTP id 97686; Mon, 06 Aug 2001 15:52:43 -0700 From: "Josh Berkus" Subject: Re: [warning: largely off-topic] Re: Data type confusion To: Allan Engelhardt Cc: pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Mon, 06 Aug 2001 15:52:43 -0700 Message-ID: In-Reply-To: <3B6F1C9F.F8421C35@cybaea.com> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200108/73 X-Sequence-Number: 4294 Allan, > Thanks for your explanation. I'd like to get hold of a copy of > SQL99/PKG001 to see what they have actually defined. Tom posted a section of this. > I think the INTERVAL type sux :-) Long rant follows - consider > hitting the delete button now. Au contraire. I replying to the list because I think that your rant is actually relevant to all date/time development. (If your post wasn't to the list, I'll forward it). > In this area, there are a number of different concepts that it would > make sense to separate. > What's an INTERVAL supposed to be? DUTIME, DLDATE, TIMEU or > something that really belongs to the CALENDAR? > > All of the above? That is a very important question to answer. Here we have an unfortunate dilemma: On the one horn: Absolute time, or UTIME, is *much* easier for a database to deal with since it follows fixed rules. LTIME or DUTIME/DLDATE etc. follow rules which may change from year to year and country to country (or state to state in the US!), making it impossible to compile such date and time rules as part of a database. On the other horn: Of course, what many/most users want is their local time and date according to local rules (admins of worldwide web servers exempted). So ... my first question: surely someone has grappled with this problem already? Surely some professor of C.S. in a university somewhere has an answer for us? -Josh P.S. My head hurts, now. ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco