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
