Re: Bad Timestamp Format

From: "Thomas O'Dowd" <tom(at)nooper(dot)com>
To: Gunaseelan Nagarajan <gnagarajan(at)dkf(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Bad Timestamp Format
Date: 2002-01-26 15:47:24
Message-ID: 20020127004724.F8130@beast.uwillsee.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

Hi Nagarajan,

What driver version are you using? The latest drivers at least
should switch the database to return ISO datestyle timestamps
when it first gets a connection. The current driver code expects
to parse the ISO format which is why you are getting this exception
below. Are you changing the datestyle in your program? I'm unfamilar
with how to get postgres to return a timestamp in the short format without
the seconds which you have below. The ISO format usually returns...
1970-01-01 00:00:00 if without time zone is specified. Can you perhaps
provide sample code that reproduces the problem using the latest driver?

You can download the latest drivers here...

http://jdbc.postgresql.org/download.html

Cheers,

Tom.

On Sat, Jan 26, 2002 at 02:33:15PM +0100, Gunaseelan Nagarajan wrote:
> hi,
> I get the following error while retrieving a datetime column using
> getTimestamp.
>
> Bad Timestamp Format at 12 in 1970-1-1 0:0;
>
>
> Bad Timestamp Format at 12 in 1970-1-1 0:0
> at org.postgresql.jdbc2.ResultSet.getTimestamp(Unknown Source)
> at org.postgresql.jdbc2.ResultSet.getTimestamp(Unknown Source)
> at
> org.jboss.pool.jdbc.ResultSetInPool.getTimestamp(ResultSetInPool.java:734)
>
> regards,
> Nagarajan.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
Thomas O'Dowd. - Nooping - http://nooper.com
tom(at)nooper(dot)com - Testing - http://nooper.co.jp/labs

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message G.Nagarajan 2002-01-26 16:14:31 Re: Bad Timestamp Format
Previous Message Gunaseelan Nagarajan 2002-01-26 13:33:15 Bad Timestamp Format

Browse pgsql-jdbc by date

  From Date Subject
Next Message G.Nagarajan 2002-01-26 16:14:31 Re: Bad Timestamp Format
Previous Message Gunaseelan Nagarajan 2002-01-26 13:33:15 Bad Timestamp Format