X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EAE02476315 for ; Mon, 12 May 2003 11:05:46 -0400 (EDT) Received: from mail01.techtelnet.net (unknown [200.69.128.98]) by postgresql.org (Postfix) with ESMTP id 3DC1147621C for ; Mon, 12 May 2003 11:05:42 -0400 (EDT) Received: (qmail 5082 invoked by uid 507); 12 May 2003 15:05:45 -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.462833 secs); 12 May 2003 15:05:45 -0000 X-Qmail-Scanner-Mail-From: lainl@aconectarse.com via mail01 X-Qmail-Scanner: 1.16 (Clear:. Processed in 0.462833 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:05:44 -0000 Date: Mon, 12 May 2003 12:05:44 -0300 From: Lucas Lain To: Bruno Wolff III Cc: pgsql-sql@postgresql.org Subject: Re: epoch to timestamp Message-Id: <20030512120544.5bb9c4c6.lainl@aconectarse.com> In-Reply-To: <20030509213648.GA13124@wolff.to> References: <20030509180545.1122c349.lainl@aconectarse.com> <20030509213648.GA13124@wolff.to> 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=-29.6 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,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/214 X-Sequence-Number: 13379 i really dont know how to do it ... i'm a newbie it is something like this? select cast(105471234 AS abstime) ... and then? 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. > -- Lucas Lain lainl@aconectarse.com