X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8A401475ADE for ; Fri, 9 May 2003 17:36:06 -0400 (EDT) Received: from wolff.to (wolff.to [66.93.249.74]) by postgresql.org (Postfix) with SMTP id D64F7474E4F for ; Fri, 9 May 2003 17:35:30 -0400 (EDT) Received: (qmail 13136 invoked by uid 500); 9 May 2003 21:36:48 -0000 Date: Fri, 9 May 2003 16:36:48 -0500 From: Bruno Wolff III To: Lucas Lain Cc: pgsql-sql@postgresql.org Subject: Re: epoch to timestamp Message-ID: <20030509213648.GA13124@wolff.to> Mail-Followup-To: Lucas Lain , pgsql-sql@postgresql.org References: <20030509180545.1122c349.lainl@aconectarse.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030509180545.1122c349.lainl@aconectarse.com> User-Agent: Mutt/1.5.4i X-Spam-Status: No, hits=-36.7 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,NO_DNS_FOR_FROM, QUOTED_EMAIL_TEXT,REFERENCES,REPLY_WITH_QUOTES, USER_AGENT_MUTT 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/190 X-Sequence-Number: 13355 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.