Re: [SQL] EPOCH TIMESTAMP Conversion Problem
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? SELECT current_date::timestamp::abstime::int4; Or less efficient? ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [SQL] EPOCH TIMESTAMP Conversion Problem
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 deprecated --- it's got a Y2038 problem. regards, tom lane ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [SQL] EPOCH TIMESTAMP Conversion Problem
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 Is using casts for the same purpose deprecated? SELECT current_date::timestamp::abstime::int4; EXTRACT is SQL-standard syntax which appeals to some people. The :: casting syntax is a Postgres extension. And from the docs: http://www.postgresql.org/docs/8.2/static/datatype-datetime.html The types abstime and reltime are lower precision types which are used internally. You are discouraged from using these types in new applications and are encouraged to move any old ones over when appropriate. Any or all of these internal types might disappear in a future release. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
