Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E6A929F94A2 for ; Wed, 7 Nov 2007 11:35:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 30253-07 for ; Wed, 7 Nov 2007 11:34:27 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 94B8C9F9270 for ; Wed, 7 Nov 2007 11:35:11 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lA7FZ9kS016806; Wed, 7 Nov 2007 10:35:09 -0500 (EST) To: "Amitanand Chikorde" cc: pgsql-sql@postgresql.org Subject: Re: EPOCH TIMESTAMP Conversion Problem In-reply-to: <7e7750290711070237x7da14616i383ace7f513f0882@mail.gmail.com> References: <7e7750290711070237x7da14616i383ace7f513f0882@mail.gmail.com> Comments: In-reply-to "Amitanand Chikorde" message dated "Wed, 07 Nov 2007 16:07:05 +0530" Date: Wed, 07 Nov 2007 10:35:08 -0500 Message-ID: <16805.1194449708@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/25 X-Sequence-Number: 29553 "Amitanand Chikorde" writes: > I want to convert MAX(mydate) from myTable to Epoch. Do you mean SELECT EXTRACT(EPOCH FROM MAX(mydate)) FROM myTable regards, tom lane