X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E64F0476340 for ; Mon, 12 May 2003 11:27:04 -0400 (EDT) Received: from mail01.techtelnet.net (unknown [200.69.128.98]) by postgresql.org (Postfix) with ESMTP id D737E474E42 for ; Mon, 12 May 2003 11:27:02 -0400 (EDT) Received: (qmail 10339 invoked by uid 507); 12 May 2003 15:27:06 -0000 Received: from lainl@aconectarse.com by mail01 by uid 504 with qmail-scanner-1.16 (clamscan: 0.54. spamassassin: 2.53. Clear:. Processed in 0.464006 secs); 12 May 2003 15:27:06 -0000 X-Qmail-Scanner-Mail-From: lainl@aconectarse.com via mail01 X-Qmail-Scanner: 1.16 (Clear:. Processed in 0.464006 secs) Received: from unknown (HELO workie.techtelnet.net) ([10.160.4.26]) (envelope-sender ) by mail (qmail-ldap-1.03) with SMTP for ; 12 May 2003 15:27:06 -0000 Date: Mon, 12 May 2003 12:27:05 -0300 From: Lucas Lain To: Achilleus Mantzios Cc: bruno@wolff.to, pgsql-sql@postgresql.org Subject: Re: epoch to timestamp Message-Id: <20030512122705.068fdb0e.lainl@aconectarse.com> In-Reply-To: References: <20030512120544.5bb9c4c6.lainl@aconectarse.com> Organization: ML X-Mailer: Sylpheed version 0.8.9 (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-23.1 required=5.0 tests=BAYES_10,IN_REP_TO,QUOTED_EMAIL_TEXT,RCVD_IN_NJABL, RCVD_IN_OSIRUSOFT_COM,REFERENCES,REPLY_WITH_QUOTES, X_NJABL_OPEN_PROXY 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/218 X-Sequence-Number: 13383 thank everybody ... thank you very much! works great! On Mon, 12 May 2003 18:30:11 -0200 (GMT+2) Achilleus Mantzios wrote: > On Mon, 12 May 2003, Lucas Lain wrote: > > > i really dont know how to do it ... i'm a newbie > > it is something like this? > > > > select cast(105471234 AS abstime) ... > > > > and then? > > Just do > select 105471234::abstime::timestamp; > > > > > > > > > On Fri, 9 May 2003 16:36:48 -0500 > > Bruno Wolff III wrote: > > > > > On Fri, May 09, 2003 at 18:05:45 -0300, > > > Lucas Lain wrote: > > > > > > > > can anyone tell me how to convert an epoch date to timestamp format?? > > > > > > If the epoch date is an integer with seconds since the unix epoch, > > > you can cast it to abstime and then to timestamp. > > > > > > > > > > > -- > ================================================================== > 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 > > -- Lucas Lain lainl@aconectarse.com