Re: Timestamp problem

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!
>