Thread: Timestamp Fractions Problem

Timestamp Fractions Problem

From
"Florian Mader"
Date:
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