Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0F811475DB4 for ; Thu, 3 Oct 2002 11:02:15 -0400 (EDT) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.236.160]) by postgresql.org (Postfix) with ESMTP id 945ED475D4B for ; Thu, 3 Oct 2002 11:02:14 -0400 (EDT) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 17x7bT-0005RH-00 for ; Thu, 03 Oct 2002 09:09:27 -0600 Date: Thu, 3 Oct 2002 09:09:27 -0600 From: Roberto Mello To: pgsql-sql@postgresql.org Subject: epoch to date Message-ID: <20021003150927.GB20452@cc.usu.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline User-Agent: Mutt/1.4i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/36 X-Sequence-Number: 9754 Hi all, Maybe I missed something obvious, but is there a built-in function to convert epoch to date? I couldn't find it in the documentation for extract and friends. Thanks, -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + All in all, you're just another brick on the wall...