Timestamp Fractions Problem

From: "Florian Mader" <florian_mader(at)gmx(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Timestamp Fractions Problem
Date: 2002-09-13 14:49:48
Message-ID: 000001c25b34$cf82d480$0300a8c0@FPCm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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


Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 2002-09-13 15:19:11 Re: [SQL] Latitude / Longitude
Previous Message Florian Mader 2002-09-13 14:38:50 Timestamp Fractions Problem