Skip site navigation (1) Skip section navigation (2)

[JDBC] timestamp parsing

From: wrobell <wrobell(at)posexperts(dot)com(dot)pl>
To: pgsql-patches(at)postgresql(dot)org
Subject: [JDBC] timestamp parsing
Date: 2000-11-20 11:43:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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(at)posexperts(dot)com(dot)pl>

pgsql-patches by date

Next:From: Karel ZakDate: 2000-11-23 11:44:21
Subject: 7.1: to_char(): Y,YY,YYY,YYYY fix
Previous:From: Peter MountDate: 2000-11-20 08:12:23
Subject: RE: [JDBC] string conversion patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group