| From: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | epoch |
| Date: | 2001-03-05 22:09:14 |
| Message-ID: | 20010305220914.D1158@quartz.newn.cam.ac.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Franck Martin | 2001-03-05 22:14:21 | RE: CORBA and PG |
| Previous Message | Peter Eisentraut | 2001-03-05 21:51:10 | pg_restore -U |