epoch - Mailing list pgsql-hackers

From Patrick Welche
Subject epoch
Date
Msg-id 20010305220914.D1158@quartz.newn.cam.ac.uk
Whole thread Raw
Responses Re: epoch
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: How to shoot yourself in the foot: kill -9 postmaster
Next
From: Tom Lane
Date:
Subject: Re: WAL-based allocation of XIDs is insecure