From: Nissim <nissim@nksystems.com>
To: pgsql-interfaces@hub.org
Subject: JDBC setTimestamp/getTimestamp
Date: Sat, 03 Jun 2000 12:12:15 -0400
Message-ID: <39392E5F.8AF61D0E@nksystems.com> (raw)
Hi,
if you do
Calendar cal = Calendar.getInstance();
cal.setTime( new java.util.Date() );
stmt.setTimeStamp( 1, new java.sql.Timestamp( cal.getTime().getTime() )
);
where param 1 is a column with datatype timestamp.
And then you do
rset.getTimeStamp( 1 );
to select the same column,
you get an exception, because the setTimeStamp did a toString() on the
java.sql.Timestamp, which returns "yyyy-mm-dd hh:mm:ss.fffffffff". Then
the select statement will return something like this: "2000-06-03
11:47:47.85-04" and the getTimeStamp tries to shove thaat into a
SimpleDateFormat initialized with this: "yyyy-MM-dd HH:mm:sszzz".
Would the following be a bad way to fix this?
Check if the string with the date value contains "." and then use a
different format string.
I think it would probably be better if the server always returned
"yyyy-MM-dd HH:mm:ss.SSSzzz" regardless of whether milliseconds were
specified in the Insert/Update.
-Nissim
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-interfaces@postgresql.org
Cc: nissim@nksystems.com, pgsql-interfaces@hub.org
Subject: Re: JDBC setTimestamp/getTimestamp
In-Reply-To: <39392E5F.8AF61D0E@nksystems.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