Problem with EXTRACT() in current sources?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Problem with EXTRACT() in current sources?
Date: 2002-08-15 05:03:33
Message-ID: 20001.1029387813@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-08-15 05:09:26 Re: contrib Makefiles
Previous Message Christopher Kings-Lynne 2002-08-15 04:43:58 Re: contrib Makefiles