Received: from web20705.mail.yahoo.com (web20705.mail.yahoo.com [216.136.226.178]) by postgresql.org (Postfix) with SMTP id 5BE24475884 for ; Wed, 24 Jul 2002 20:48:16 -0400 (EDT) Message-ID: <20020725004819.8083.qmail@web20705.mail.yahoo.com> Received: from [66.108.196.111] by web20705.mail.yahoo.com via HTTP; Wed, 24 Jul 2002 17:48:19 PDT Date: Wed, 24 Jul 2002 17:48:19 -0700 (PDT) From: marc sturm Subject: convert a bigint into a timestamp To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200207/393 X-Sequence-Number: 8771 Hello, Does anyone know how to convert a bigint into a date or timestamp in a SQL query. Thanks a lot. Marc __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com