From florian_mader@gmx.net Fri Sep 13 14:39:45 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 55A64475DDB for ; 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 ; 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" To: 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 From florian_mader@gmx.net Fri Sep 13 14:50:42 2002 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-- From tgl@sss.pgh.pa.us Sat Sep 14 03:35:24 2002 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? From florian_mader@gmx.net Sun Sep 15 09:00:55 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 12CA0475B84 for ; Sun, 15 Sep 2002 05:00:55 -0400 (EDT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id D1AC2475A3F for ; Sun, 15 Sep 2002 05:00:53 -0400 (EDT) Received: (qmail 16517 invoked by uid 0); 15 Sep 2002 09:00:53 -0000 Received: from chello080110012194.202.12.wu-wien.teleweb.at (HELO FPCm) (80.110.12.194) by mail.gmx.net (mp017-rz3) with SMTP; 15 Sep 2002 09:00:53 -0000 From: "Florian Mader" To: Subject: Re: Timestamp Fractions Problem Date: Sun, 15 Sep 2002 11:00:05 +0200 Message-ID: <000301c25c96$4a4375a0$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/151 X-Sequence-Number: 9428 Thank you Tom for the reply! Now I tried the same create, insert and select statement you did. But the DB didn't return fractions like it did in your case. I only got this mod_ ------------------- 2002-09-14 10:45:32 I am using WinSQL and the ODBC Driver I found on http://odbc.postgresql.org Are there any special settings needed for the ODBC Driver? They are currently set to default. TIA Florian From tgl@sss.pgh.pa.us Sun Sep 15 14:52:03 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 344924762D1 for ; Sun, 15 Sep 2002 10:52:03 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 89A324762CC for ; Sun, 15 Sep 2002 10:52:02 -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 g8FEpg5D028672; Sun, 15 Sep 2002 10:51:42 -0400 (EDT) To: "Florian Mader" Cc: pgsql-sql@postgresql.org Subject: Re: Timestamp Fractions Problem In-reply-to: <000301c25c96$4a4375a0$0300a8c0@FPCm> References: <000301c25c96$4a4375a0$0300a8c0@FPCm> Comments: In-reply-to "Florian Mader" message dated "Sun, 15 Sep 2002 11:00:05 +0200" Date: Sun, 15 Sep 2002 10:51:42 -0400 Message-ID: <28671.1032101502@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/152 X-Sequence-Number: 9429 "Florian Mader" writes: > Now I tried the same create, insert and select statement you did. But > the DB didn't return fractions like it did in your case. Hm, what PG version are you running? You need 7.2 or later to have full support for fractional timestamps (in particular, the result of now() is only good to the nearest second in prior versions). regards, tom lane From florian_mader@gmx.net Mon Sep 16 08:30:03 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 97438475BC3 for ; Mon, 16 Sep 2002 04:30:03 -0400 (EDT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id E24B9475AD7 for ; Mon, 16 Sep 2002 04:30:01 -0400 (EDT) Received: (qmail 18152 invoked by uid 0); 16 Sep 2002 08:30:02 -0000 Received: from chello080110012194.202.12.wu-wien.teleweb.at (HELO FPCm) (80.110.12.194) by mail.gmx.net (mp001-rz3) with SMTP; 16 Sep 2002 08:30:02 -0000 From: "Florian Mader" To: Subject: Re: Timestamp Fractions Problem Date: Mon, 16 Sep 2002 10:29:13 +0200 Message-ID: <000001c25d5b$241aabd0$0300a8c0@FPCm> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 Importance: Normal In-Reply-To: <28671.1032101502@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/154 X-Sequence-Number: 9431 I am using: PostgreSQL 7.2.2 ODBC Driver 7.02.00.02 Cygwin 1.3.12-2 Win2000 5.00.2195 SP2 WinSQL 3.8.19.499 I don't think that there's a problem with my versions. Do you have any other idea? TIA -----Urspr=FCngliche Nachricht----- Von: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20 Gesendet: Sonntag, 15. September 2002 16:52 An: Florian Mader Cc: pgsql-sql@postgresql.org Betreff: Re: [SQL] Timestamp Fractions Problem=20 "Florian Mader" writes: > Now I tried the same create, insert and select statement you did. But > the DB didn't return fractions like it did in your case. Hm, what PG version are you running? You need 7.2 or later to have full support for fractional timestamps (in particular, the result of now() is only good to the nearest second in prior versions). regards, tom lane