X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5309432A2C0 for ; Wed, 29 Sep 2004 14:22:10 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31072-05 for ; Wed, 29 Sep 2004 13:21:56 +0000 (GMT) Received: from tank.sv.lnf.it (host30-191.pool80206.interbusiness.it [80.206.191.30]) by svr1.postgresql.org (Postfix) with ESMTP id E7D1332A15D for ; Wed, 29 Sep 2004 14:21:54 +0100 (BST) Received: from [10.5.1.3] (helo=neo.sv.lnf.it ident=mail) by tank.sv.lnf.it with esmtp (Exim 3.35 #1 (Debian)) id 1CCeOi-0007CJ-00; Wed, 29 Sep 2004 15:21:32 +0200 Received: from [10.5.1.18] (helo=bilbo.sv.lnf.it) by neo.sv.lnf.it with esmtp (Exim 3.35 #1 (Debian)) id 1CCeOW-0003uf-00; Wed, 29 Sep 2004 15:21:20 +0200 Received: from gaio by bilbo.sv.lnf.it with local (Exim 3.36 #1 (Debian)) id 1CCeOX-0000s4-00; Wed, 29 Sep 2004 15:21:21 +0200 Date: Wed, 29 Sep 2004 15:21:21 +0200 From: Marco Gaiarin To: Jeff , pgsql-sql@postgresql.org Subject: Re: Porting problem from Informix to Postgres... Message-ID: <20040929132121.GL2534@sv.lnf.it> References: <20040922121758.GG2319@sv.lnf.it> <40C061B2-0CAF-11D9-99D5-000D9366F0C4@torgo.978.org> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <40C061B2-0CAF-11D9-99D5-000D9366F0C4@torgo.978.org> Organization: La Nostra Famiglia - Polo FVG User-Agent: Mutt/1.5.6+20040722i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/253 X-Sequence-Number: 19099 Mandi! Jeff In chel di` si favelave... > 1. use to_char to format the date however you like ...this seems the best solution, many thanks to all! ;) -- dott. Marco Gaiarin GNUPG Key ID: 240A3D66 Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/ Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN) gaio(at)sv.lnf.it tel +39-0434-842711 fax +39-0434-842797 Urbani, dimissioni please http://punto-informatico.it/p.asp?i=49171