Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7AMWaP11318 for ; Fri, 10 Aug 2001 18:32:36 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f7AMW2864493 for pgsql-sql@postgresql.org; Fri, 10 Aug 2001 18:32:02 -0400 (EDT) (envelope-from news) From: Allan Engelhardt X-Newsgroups: comp.databases.postgresql.sql Subject: BUG in EXTRACT(MICROSECONDS...)? Date: Fri, 10 Aug 2001 23:32:38 +0100 Organization: http://cybaea.com/ Message-ID: <3B746106.294ED058@cybaea.com> X-NNTP-Posting-Host: engelhardt.demon.co.uk:193.237.12.86 X-Complaints-To: abuse@demon.net X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.7 i686) X-Accept-Language: en MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 29 To: pgsql-sql@postgresql.org X-Archive-Number: 200108/145 X-Sequence-Number: 4366 Shouldn't EXTRACT treat TIME and TIMESTAMP the same when you are extracting time elements? --- Allan. test=# SELECT EXTRACT(MICROSECONDS FROM TIMESTAMP '2001-01-01 17:12:28.5'); date_part ----------- 500000 (1 row) test=# SELECT EXTRACT(MICROSECONDS FROM TIME '17:12:28.5'); date_part ----------- 28500000 (1 row) === Name : postgresql Relocations: (not relocateable) Version : 7.1.2 Vendor: (none) Release : 4PGDG Build Date: Wed Jun 13 22:18:46 2001Install date: Fri Jun 29 20:43:51 2001 Build Host: lowen.wgcr.org Group : Applications/Databases Source RPM: postgresql-7.1.2-4PGDG.src.rpm Size : 4426307 License: BSD URL : http://www.postgresql.org/ Summary : PostgreSQL client programs and libraries.