Postgres Pro
Downloads
Home   >   mailing lists

Problem with EXTRACT() in current sources? - Mailing list pgsql-hackers

From Tom Lane
Subject Problem with EXTRACT() in current sources?
Date
Msg-id 20001.1029387813@sss.pgh.pa.us
Whole thread Raw
List pgsql-hackers
Tree view 
I believe that
SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40');
ahould give a fairly large integer --- in 7.2 I get 982373920.
But CVS tip (without the int64-timestamp option) produces
982.35592.  Broken, no?
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: contrib Makefiles
Next
From: Tom Lane
Date:
Subject: Re: contrib Makefiles