Re: [SQL] EPOCH TIMESTAMP Conversion Problem

2008-01-01 Thread Michael Glaesemann
On Jan 1, 2008, at 9:28 , Louis-David Mitterrand wrote: On Wed, Nov 07, 2007 at 10:35:08AM -0500, Tom Lane wrote: "Amitanand Chikorde" <[EMAIL PROTECTED]> writes: I want to convert MAX(mydate) from myTable to Epoch. Do you mean SELECT EXTRACT(EPOCH FROM MAX(mydate)) FROM myTable I

Re: [SQL] EPOCH TIMESTAMP Conversion Problem

2008-01-01 Thread Tom Lane
Louis-David Mitterrand <[EMAIL PROTECTED]> writes: > On Wed, Nov 07, 2007 at 10:35:08AM -0500, Tom Lane wrote: >> SELECT EXTRACT(EPOCH FROM MAX(mydate)) FROM myTable > Is using casts for the same purpose deprecated? > SELECT current_date::timestamp::abstime::int4; Well, type abstime is dep

Re: [SQL] EPOCH TIMESTAMP Conversion Problem

2008-01-01 Thread Louis-David Mitterrand
On Wed, Nov 07, 2007 at 10:35:08AM -0500, Tom Lane wrote: > "Amitanand Chikorde" <[EMAIL PROTECTED]> 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?