X-Original-To: pgsql-novice@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id F35C8475EC9 for ; Tue, 8 Apr 2003 08:37:40 -0400 (EDT) Received: from gerstung3.net-lab.net (gerstung3.net-lab.net [80.69.32.16]) by postgresql.org (Postfix) with ESMTP id 4B590474E42 for ; Tue, 8 Apr 2003 08:37:36 -0400 (EDT) Received: from [10.20.30.20] (gw-in.of.net-lab.net [80.69.37.2]) by gerstung3.net-lab.net (Postfix) with ESMTP id 66C39474327; Tue, 8 Apr 2003 14:40:43 +0200 (CEST) Subject: Re: Date Format From: Nabil Sayegh To: Ben Clewett Cc: pgsql-novice In-Reply-To: <3E929D74.5010705@roadrunner.uk.com> References: <3E929D74.5010705@roadrunner.uk.com> Content-Type: text/plain Organization: e-trolley Message-Id: <1049805454.28062.3.camel@billy> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 Date: 08 Apr 2003 14:37:34 +0200 Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-31.5 required=5.0 tests=BAYES_10,IN_REP_TO,QUOTED_EMAIL_TEXT,REFERENCES, REPLY_WITH_QUOTES,USER_AGENT_XIMIAN autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/68 X-Sequence-Number: 6649 Am Die, 2003-04-08 um 11.59 schrieb Ben Clewett: > Has any member developed any way of having a more elaborate formats. > Like, idealy, an Agregate function which sets the date to any desired > format? AFAIR an aggregate is something that summarizes many rows to 1 row like: avg(), sum() etc. (in grouped queries) cu -- e-Trolley Sayegh & John, Nabil Sayegh Tel.: 0700 etrolley /// 0700 38765539 Fax.: +49 69 8299381-8 PGP : www.e-trolley.de