Re: Problem in ResultSet#getTimestamp() of 7.2b4 - Mailing list pgsql-jdbc

From Bruce Momjian
Subject Re: Problem in ResultSet#getTimestamp() of 7.2b4
Date
Msg-id 200201250208.g0P28JT09512@candle.pha.pa.us
Whole thread Raw
In response to Re: Problem in ResultSet#getTimestamp() of 7.2b4  (Ryouichi Matsuda <r-matuda@sra.co.jp>)
List pgsql-jdbc
This has been saved for the 7.3 release:

    http://candle.pha.pa.us/cgi-bin/pgpatches2

---------------------------------------------------------------------------

Ryouichi Matsuda wrote:
> Barry Lind wrote:
> > Then however I did try your last query:
> >
> > select 'now'::timestamp without time zone;
> >
> > and this does fail for me with the string index out of bounds exception.
>
> An attached patch corrects problem of this bug and fractional second.
>
>
> The handling of time zone was as follows:
>
>   (a) with time zone
>       using  SimpleDateFormat("yyyy-MM-dd HH:mm:ss z")
>   (b) without time zone
>       using  SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
>
>
> About problem of fractional second,
> Fractional second was changed from milli-second to nano-second.

[ Attachment, skipping... ]

[ Attachment, skipping... ]

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-jdbc by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Problem in ResultSet#getTimestamp() of 7.2b4
Next
From: "Sulakshana Awsarikar"
Date:
Subject: Inserting Non English characters in a varchar type field