Home > mailing lists

Re: EPOCH TIMESTAMP Conversion Problem - Mailing list pgsql-sql

From	Tom Lane
Subject	Re: EPOCH TIMESTAMP Conversion Problem
Date	November 7, 2007 14:35:15
Msg-id	16805.1194449708@sss.pgh.pa.us Whole thread Raw
In response to	EPOCH TIMESTAMP Conversion Problem ("Amitanand Chikorde" <amit99rs@gmail.com>)
Responses	Re: EPOCH TIMESTAMP Conversion Problem (Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>)
List	pgsql-sql

Tree view

"Amitanand Chikorde" <amit99rs@gmail.com> writes:
> I want to convert MAX(mydate) from myTable to Epoch.

Do you meanSELECT EXTRACT(EPOCH FROM MAX(mydate)) FROM myTable
        regards, tom lane

pgsql-sql by date:

From: "Philippe Lang"
Date: 07 November 2007, 12:23:08
Subject: Temporal databases

From: Vivek Khera
Date: 08 November 2007, 15:49:14
Subject: Re: Partitioning and Foreign Keys

Re: EPOCH TIMESTAMP Conversion Problem - Mailing list pgsql-sql

Previous

Next