X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 87B7F475EE2 for ; Thu, 8 May 2003 15:44:28 -0400 (EDT) Received: from taka.swcp.com (taka.swcp.com [198.59.115.12]) by postgresql.org (Postfix) with ESMTP id A485E474E4F for ; Thu, 8 May 2003 15:44:24 -0400 (EDT) Received: from ARCplanning.com (pcp02742825pcs.sntafe01.nm.comcast.net [68.35.10.62]) by taka.swcp.com (8.12.9/8.12.9) with ESMTP id h48JiNpu014942 for ; Thu, 8 May 2003 13:44:24 -0600 (MDT) Date: Thu, 8 May 2003 13:44:22 -0600 Mime-Version: 1.0 (Apple Message framework v552) Content-Type: text/plain; charset=US-ASCII; format=flowed Subject: epoch to date? From: Alex Rice To: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit Message-Id: <7784EC60-818D-11D7-A998-000393529642@ARCplanning.com> X-Mailer: Apple Mail (2.552) X-Spam-Status: No, hits=-8.9 required=5.0 tests=BAYES_10,USER_AGENT_APPLEMAIL 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/180 X-Sequence-Number: 13345 I have a column with seconds since the unix epoch. How to convert it to date? Sorry I couldn't find it in the docs. Alex Rice, Software Developer Architectural Research Consultants, Inc. alrice@ARCplanning.com alrice@swcp.com