Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 46DDB2E2FCE for ; Tue, 1 Jan 2008 10:28:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 86916-03 for ; Tue, 1 Jan 2008 10:28:33 -0400 (AST) Received: from sargon.lncsa.com (sargon.lncsa.com [212.99.8.251]) by postgresql.org (Postfix) with ESMTP id 7C4972E2FD7 for ; Tue, 1 Jan 2008 10:28:39 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by sargon.lncsa.com (Postfix) with ESMTP id 2EE6730A901A for ; Tue, 1 Jan 2008 15:28:37 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at lncsa.com Received: from sargon.lncsa.com ([127.0.0.1]) by localhost (sargon.lncsa.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id jyfDgqNk9OrZ for ; Tue, 1 Jan 2008 15:28:37 +0100 (CET) Received: from zenon.apartia.fr (zenon.apartia.fr [10.0.3.1]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "zenon.apartia.fr", Issuer "ca.apartia.fr" (verified OK)) by sargon.lncsa.com (Postfix) with ESMTP id 0FAD53000407 for ; Tue, 1 Jan 2008 15:28:37 +0100 (CET) Received: from timgad.apartia.fr (timgad.apartia.fr [10.0.3.101]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "timgad.apartia.fr", Issuer "ca.apartia.fr" (verified OK)) by zenon.apartia.fr (Postfix) with ESMTP id 8151059C5B403 for ; Tue, 1 Jan 2008 15:28:36 +0100 (CET) Received: by timgad.apartia.fr (Postfix, from userid 1000) id 2B2332C00F658; Tue, 1 Jan 2008 15:28:37 +0100 (CET) Date: Tue, 1 Jan 2008 15:28:37 +0100 From: Louis-David Mitterrand To: pgsql-sql@postgresql.org Subject: Re: EPOCH TIMESTAMP Conversion Problem Message-ID: <20080101142837.GA24772@apartia.fr> Mail-Followup-To: pgsql-sql@postgresql.org References: <7e7750290711070237x7da14616i383ace7f513f0882@mail.gmail.com> <16805.1194449708@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <16805.1194449708@sss.pgh.pa.us> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/5 X-Sequence-Number: 29859 On Wed, Nov 07, 2007 at 10:35:08AM -0500, Tom Lane wrote: > "Amitanand Chikorde" writes: > > I want to convert MAX(mydate) from myTable to Epoch. > > Do you mean > SELECT EXTRACT(EPOCH FROM MAX(mydate)) FROM myTable Is using casts for the same purpose deprecated? SELECT current_date::timestamp::abstime::int4; Or less efficient?