Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 180AA476283 for ; Fri, 13 Sep 2002 10:50:42 -0400 (EDT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id B145747612C for ; Fri, 13 Sep 2002 10:50:40 -0400 (EDT) Received: (qmail 16167 invoked by uid 0); 13 Sep 2002 14:50:43 -0000 Received: from chello080110012194.202.12.wu-wien.teleweb.at (HELO FPCm) (80.110.12.194) by mail.gmx.net (mp013-rz3) with SMTP; 13 Sep 2002 14:50:43 -0000 From: "Florian Mader" To: Subject: Timestamp Fractions Problem Date: Fri, 13 Sep 2002 16:49:48 +0200 Message-ID: <000001c25b34$cf82d480$0300a8c0@FPCm> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01C25B45.930D2B20" 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/136 X-Sequence-Number: 9413 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C25B45.930D2B20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0001_01C25B45.930D2B20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,=

I have got a real= ly big problem with queries for Timestamp-Values.

=A0=A0=A0=A0=A0 select mod_ from TMODUL

This query, sent = to a DBII returns the value

=A0=A0=A0=A0=A0 2002-09-11 17:47:30.017000=

The same query se= nt to a PostgreSQL returns the value

=A0=A0=A0=A0=A0 2002-09-11 <= st1:time Hour=3D"17" Minute=3D"47">17:47:30

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

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

returns also

=A0=A0=A0=A0=A0 2002-09-11 17:47:30.017000=

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

Platform Info

OS: Win2000<= /o:p>

Emulator: cygWin<= o:p>

PostgreSQL: 7.2.1=

Does anybody have= an idea?

TIA

Florian

------=_NextPart_000_0001_01C25B45.930D2B20--