Skip site navigation (1) Skip section navigation (2)

epoch

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 (view raw or flat)
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

Responses

  • Re: epoch at 2001-03-06 20:39:13 from Peter Eisentraut

pgsql-hackers by date

Next:From: Franck MartinDate: 2001-03-05 22:14:21
Subject: RE: CORBA and PG
Previous:From: Peter EisentrautDate: 2001-03-05 21:51:10
Subject: pg_restore -U

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group