X-Original-To: pgsql-novice@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A1BC44762E0 for ; Tue, 8 Apr 2003 10:48:13 -0400 (EDT) Received: from pop3.road-runner.net (pop3.road-runner.net [193.133.123.198]) by postgresql.org (Postfix) with ESMTP id 9BC9F4762BB for ; Tue, 8 Apr 2003 10:48:12 -0400 (EDT) Received: from roadrunner.uk.com (aps.web.roadrunner.uk.com [193.133.123.182]) by pop3.road-runner.net (8.12.3/8.12.3) with ESMTP id h38FA73B020246; Tue, 8 Apr 2003 16:10:07 +0100 Message-ID: <3E92E1B5.9060201@roadrunner.uk.com> Date: Tue, 08 Apr 2003 15:50:29 +0100 From: Ben Clewett User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3b) Gecko/20030210 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-novice@postgresql.org Subject: Re: Date Format References: <3E929D74.5010705@roadrunner.uk.com> <26749.1049812422@sss.pgh.pa.us> In-Reply-To: <26749.1049812422@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-38.8 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MOZILLA_UA 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/72 X-Sequence-Number: 6653 I see... Found the reference: http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=functions-formatting.html to_char(my_timestamp, 'DD/MM/YY') This looks really exactly what I want, thanks! Ben Tom Lane wrote: > Ben Clewett writes: > >>Has any member developed any way of having a more elaborate formats. > > > There's always to_char() ... it's pretty ugly but can format a date > practically any way you want. > > regards, tom lane >