Thread: Timestamp problem

Timestamp problem

From

Raymond Chui

Date:

20 July 2003, 05:26:43

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!

--
Raymond Chui
NWS at NOAA
301-713-0640 ext 168

Re: Timestamp problem

From

Barry Lind

Date:

21 July 2003, 18:56:12

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