pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Florian Mader <florian_mader@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Timestamp Fractions Problem
Date: Fri, 13 Sep 2002 16:49:48 +0200
Message-ID: <000001c25b34$cf82d480$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
 
 

view thread (6+ messages)  latest in thread

Message-ID: <000001c25b34$cf82d480$0300a8c0@FPCm>
Permalink:  ../000001c25b34$cf82d480$0300a8c0@FPCm/
Also on:    postgresql.org/message-id/000001c25b34$cf82d480$0300a8c0@FPCm

copy link · copy postgr.es

reply

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: <000001c25b34$cf82d480$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