[JDBC] timestamp parsing

Поиск
Список
Период
Сортировка
От wrobell
Тема [JDBC] timestamp parsing
Дата
Msg-id 20001120124301.E1889@pred.posexperts.com.pl
обсуждение исходный текст
Список pgsql-patches
Current timestamp parsing is quite complex and buggy
in my opinion, i.e. '2000-09-22 13:21:39+02' works (inserted
with now() function) but inserting '2000-09-22 13:21:39.11+02'::timestamp
(important is '.11+02') does not work (as I know). The problem
exists because postgresql _does_not_ show timestamp in unambiguous way.

After applying attached patch, JDBC sets datestyle to SQL and
uses 'MM/dd/yyyy HH:mm:ss.SS zzzz' format to parse a timestamp.

However the question remains. What should be fixed? JDBC or postgresql?

  wrobell <wrobell@posexperts.com.pl>

Вложения

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

Предыдущее
От: Karel Zak
Дата:
Сообщение: 7.1: to_char(): Y,YY,YYY,YYYY fix
Следующее
От: Peter Mount
Дата:
Сообщение: RE: [JDBC] timestamp parsing