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

Timestamp problem

From: Raymond Chui <raymond(dot)chui(at)noaa(dot)gov>
To: pgsql-jdbc(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org,pgsql-bugs(at)postgresql(dot)org, pgadmin-support(at)postgresql(dot)org(dot)
Subject: Timestamp problem
Date: 2003-07-15 19:15:58
Message-ID: 3F1452EE.7000509@noaa.gov (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-bugspgsql-jdbcpgsql-sql
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



Responses

pgsql-sql by date

Next:From: Lauren MathesonDate: 2003-07-15 22:13:27
Subject: changing an update via rules
Previous:From: Michael S. TibbettsDate: 2003-07-15 19:09:22
Subject: min() and NaN

pgsql-jdbc by date

Next:From: Pedro GalanDate: 2003-07-16 08:37:03
Subject: Problems with Spanish Chars
Previous:From: floydsDate: 2003-07-15 16:13:56
Subject: column doesn't get calculated

pgsql-bugs by date

Next:From: Tom LaneDate: 2003-07-15 19:44:07
Subject: Re: [GENERAL] INSTEAD rule bug?
Previous:From: Dmitry TkachDate: 2003-07-15 19:12:05
Subject: Re: [GENERAL] INSTEAD rule bug?

pgadmin-support by date

Next:From: Matej RizmanDate: 2003-07-15 23:34:15
Subject: BUG: pgAdmin III View table with empty strings
Previous:From: Troels ArvinDate: 2003-07-15 11:59:30
Subject: Re: pgadmin III connection dialogue: cannot

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