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> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: florian_mader@gmx.net
Subject: Re: Timestamp Fractions Problem
In-Reply-To: <000001c25b33$487a75c0$0300a8c0@FPCm>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox