X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A6A6547637C for ; Mon, 12 May 2003 11:35:01 -0400 (EDT) Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (Postfix) with ESMTP id 70C9E476375 for ; Mon, 12 May 2003 11:35:00 -0400 (EDT) Received: from lerlaptop.iadfw.net (lerlaptop.iadfw.net [206.66.13.21]) (authenticated bits=0) by lerami.lerctr.org (8.12.9/8.12.9/20030225) with ESMTP id h4CFZ0KK022549; Mon, 12 May 2003 10:35:00 -0500 (CDT) Date: Mon, 12 May 2003 10:35:00 -0500 From: Larry Rosenman To: Achilleus Mantzios Cc: pgsql-sql@postgresql.org Subject: Re: epoch to timestamp Message-ID: <93440000.1052753700@lerlaptop.iadfw.net> In-Reply-To: References: X-Mailer: Mulberry/3.0.3 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Spam-Status: No, hits=-26.0 required=5.0 tests=BAYES_01,IN_REP_TO,QUOTED_EMAIL_TEXT,REFERENCES, REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/220 X-Sequence-Number: 13385 --On Monday, May 12, 2003 18:39:59 -0200 Achilleus Mantzios wrote: > On Mon, 12 May 2003, Larry Rosenman wrote: > > As an example see: > > select date_part('minute',(105471234::abstime::timestamp) + ('10 > years')::interval); > I actually have just seconds (from my LD carrier), and want to store it in hours/minutes/seconds. >> > >> Along the same lines, how can I get from seconds to hour/minute/seconds? >> >> (an interval?) >> >> >> > > -- > ================================================================== > Achilleus Mantzios > S/W Engineer > IT dept > Dynacom Tankers Mngmt > Nikis 4, Glyfada > Athens 16610 > Greece > tel: +30-210-8981112 > fax: +30-210-8981877 > email: achill@matrix.gatewaynet.com > mantzios@softlab.ece.ntua.gr -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749