> SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40');
> This example won't run on the v7.0.3...
> However, the same SQL sample runs on v7.1.2. Am I doing something wrong
> here? Is this a known bug?
For versions prior to 7.1 (and for current versions also), try
SELECT EXTRACT('epoch' FROM TIMESTAMP '2001-02-16 20:38:40');
(note the single quotes around "epoch"). 7.1.x also allows the
non-quoted form you gave as an example.
In response to
pgsql-bugs by date
|Next:||From: pgsql-bugs||Date: 2001-08-08 22:44:20|
|Subject: timestamp handling in postgres 7.1 behaves strange|
|Previous:||From: Nabil Sayegh||Date: 2001-08-07 18:37:26|
|Subject: Re: locale and german umlauts|