Trying example from:

http://www.postgresql.org/devel-corner/docs/user/functions-datetime.html

patrimoine=# SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40');
ERROR:  parser: parse error at or near "epoch"
patrimoine=# select version();
                                    version                                    
-------------------------------------------------------------------------------
 PostgreSQL 7.1beta3 on i386-unknown-netbsdelf1.5Q, compiled by GCC egcs-1.1.2
(1 row)

patrimoine=# select date_part('epoch','2001-02-16 20:38:40'::timestamp);
 date_part 
-----------
 982355920
(1 row)

Is my version already too old?

Cheers,

Patrick

Mon, 5 Mar 2001 22:09:14 +0000
Patrick Welche <prlw1@newn.cam.ac.uk>
epoch
Patrick Welche writes:

> http://www.postgresql.org/devel-corner/docs/user/functions-datetime.html
>
> patrimoine=# SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40');
> ERROR:  parser: parse error at or near "epoch"
> patrimoine=# select version();
>                                     version
> -------------------------------------------------------------------------------
>  PostgreSQL 7.1beta3 on i386-unknown-netbsdelf1.5Q, compiled by GCC egcs-1.1.2
> (1 row)

> Is my version already too old?

Yes.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Tue, 6 Mar 2001 21:39:13 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: epoch