Timestamp Fractions Problem

Поиск
Список
Период
Сортировка
От Florian Mader
Тема Timestamp Fractions Problem
Дата
Msg-id 000001c25b34$cf82d480$0300a8c0@FPCm
обсуждение исходный текст
Ответы Re: Timestamp Fractions Problem
Список 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

 

 

В списке pgsql-sql по дате отправления: