| 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:38:50 |
| Message-ID: | 000001c25b33$487a75c0$0300a8c0@FPCm |
| Views: | Whole Thread | Raw Message | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Florian Mader | 2002-09-13 14:49:48 | Timestamp Fractions Problem |
| Previous Message | Chad Thompson | 2002-09-13 14:35:39 | Re: DISTINCT ON |