Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 55A64475DDB
	for <pgsql-sql@postgresql.org>; Fri, 13 Sep 2002 10:39:45 -0400 (EDT)
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by postgresql.org (Postfix) with SMTP id 47FF3475D4B
	for <pgsql-sql@postgresql.org>; Fri, 13 Sep 2002 10:39:44 -0400 (EDT)
Received: (qmail 23539 invoked by uid 0); 13 Sep 2002 14:39:47 -0000
Received: from chello080110012194.202.12.wu-wien.teleweb.at (HELO FPCm)
	(80.110.12.194)
	by mail.gmx.net (mp008-rz3) with SMTP; 13 Sep 2002 14:39:47 -0000
From: "Florian Mader" <florian_mader@gmx.net>
To: <pgsql-sql@postgresql.org>
Subject: Timestamp Fractions Problem
Date: Fri, 13 Sep 2002 16:38:50 +0200
Message-ID: <000001c25b33$487a75c0$0300a8c0@FPCm>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.2627
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/168
X-Sequence-Number: 9445

Hello,

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

I know that the fractions are also stored in the PostgreSQL, because the
query

	select to_char(mod_, 'YYYY-MM-DD HH24:MI:SS.US') from TMODUL

returns also

	2002-09-11 17:47:30.017000

What's the property I have to set, so that an ordinary "select mod_ from
TMODUL" also returns fractions?

Platform Info
OS: Win2000
Emulator: cygWin
PostgreSQL: 7.2.1

Does anybody have an idea?
TIA
Florian