X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D4B9C475B85 for ; Fri, 9 May 2003 17:06:21 -0400 (EDT) Received: from mail01.techtelnet.net (unknown [200.69.128.98]) by postgresql.org (Postfix) with ESMTP id B3B20475E82 for ; Fri, 9 May 2003 17:05:45 -0400 (EDT) Received: (qmail 5511 invoked by uid 507); 9 May 2003 21:05:46 -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.477217 secs); 09 May 2003 21:05:46 -0000 X-Qmail-Scanner-Mail-From: lainl@aconectarse.com via mail01 X-Qmail-Scanner: 1.16 (Clear:. Processed in 0.477217 secs) Received: from unknown (HELO workie.techtelnet.net) ([10.160.4.26]) (envelope-sender ) by mail (qmail-ldap-1.03) with SMTP for ; 9 May 2003 21:05:45 -0000 Date: Fri, 9 May 2003 18:05:45 -0300 From: Lucas Lain To: pgsql-sql@postgresql.org Subject: epoch to timestamp Message-Id: <20030509180545.1122c349.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=-1.8 required=5.0 tests=BAYES_20,NO_DNS_FOR_FROM version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/189 X-Sequence-Number: 13354 can anyone tell me how to convert an epoch date to timestamp format?? TIA, -- Lucas Lain