Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A9432475F25 for ; Fri, 13 Sep 2002 23:35:24 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 0E5D1475F00 for ; Fri, 13 Sep 2002 23:35:24 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g8E3Z45D023280; Fri, 13 Sep 2002 23:35:04 -0400 (EDT) To: "Florian Mader" Cc: pgsql-sql@postgresql.org Subject: Re: Timestamp Fractions Problem In-reply-to: <000001c25b34$cf82d480$0300a8c0@FPCm> References: <000001c25b34$cf82d480$0300a8c0@FPCm> Comments: In-reply-to "Florian Mader" message dated "Fri, 13 Sep 2002 16:49:48 +0200" Date: Fri, 13 Sep 2002 23:35:03 -0400 Message-ID: <23279.1031974503@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/148 X-Sequence-Number: 9425 "Florian Mader" writes: > I have got a really big problem with queries for Timestamp-Values. > select mod_ from TMODUL > This query, sent to a DBII returns the value > 2002-09-11 17:47:30.017000 > The same query sent to a PostgreSQL returns the value > 2002-09-11 17:47:30 Around here I get regression=# select mod_ from TMODUL ; ERROR: Relation "tmodul" does not exist If I guess about what you meant then I get: regression=# create table TMODUL(mod_ timestamp); CREATE TABLE regression=# insert into TMODUL values (now()); INSERT 1062096 1 regression=# select mod_ from TMODUL ; mod_ ---------------------------- 2002-09-13 23:33:53.516852 (1 row) Perhaps you should be a tad more specific about how your table is declared and what you are doing to put data into it. regards, tom lane PS: could we also ask you to suppress HTML output from your mailer?