From: Barry Lind <blind@xythos.com>
To: Raymond Chui <raymond.chui@noaa.gov>
Cc: pgsql-jdbc@postgresql.org
Subject: Re: Timestamp problem
Date: Mon, 21 Jul 2003 11:55:59 -0700
Message-ID: <3F1C373F.7070409@xythos.com> (raw)
In-Reply-To: <3F1452EE.7000509@noaa.gov>
References: <3F1452EE.7000509@noaa.gov>
Raymond,
Upgrade to the latest stable driver. You can download it from
jdbc.postgresql.org.
--Barry
Raymond Chui wrote:
> I am use PostgreSQL 7.2.1 in Redhat Linux 7.2
> Java 1.4.x
>
> When I do JDBC
>
> String sql = "SELECT datetime_column FROM mytable";
> ....
>
> Timestamp ts = resultSet.getTimestamp(2);
>
> If the timestamp return format like
>
> 2003-07-15 13:20:00.20+00
>
> then is OK. But if timestamp return like
>
> 2003-07-15 13:20:00.421+00
>
> Then I got SQLException
>
> Bad Timestamp Format at 23 in 2003-07-14 14:45:00.421+00
>
> What is 23?
> How do I resolve this problem?
>
> Thank Q!
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: blind@xythos.com, raymond.chui@noaa.gov, pgsql-jdbc@postgresql.org
Subject: Re: Timestamp problem
In-Reply-To: <3F1C373F.7070409@xythos.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox