agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] date handling...
Date: Sun, 14 Aug 2005 10:13:07 +0200
Message-ID: <thhal-0mJXaA8vb77Q90ldIzVVlM69mQSE96J@mailblocks.com> (raw)
In-Reply-To: <1123994718.4039.9.camel@sat1>
References: <1123994718.4039.9.camel@sat1>
<42FEFD13.50105@mailblocks.com>
<thhal-0lZXaA8nb77QjhhwfRSXknpOHCNVrQP@mailblocks.com>
George,
This is probably a bug. PL/Java has to do some adjustements in order to
get java.sql.Date to work correctly but something is obviously wrong.
A java.sql.Date in java extends from java.util.Date. It's internal
representation is in milliseconds since midnight 1970-01-01. If the
timezone used by your server differs from the one that the JVM uses,
"midnight" may be translated some time in the evening the day before.
Can you please print the timezone that your server uses and the timezone
that the JVM thinks it has, i.e. TimeZone.getDefault() and see if
there's a differenence?
Regards,
Thomas Hallgren
George McQuade wrote:
>Hello list,
>
>We have successfully installed pljava on a postgres 7.4.1 system running
>under Fedora Core 1. Everything seems to work fine except for a date
>handling issue.
>
>The listed function attempts to retrieve a date from the db.
>
>The birthdate column is of pg type "Date".
>
>The logger will output "Birthdate 2005-07-31"
>The birthdate stored for custid=385 is 2005-08-01.
>
>Seems the builtin pljava jdbc driver is performing some sort of timezone
>adjustment. Has anyone run into this before?
>
>Thanks
>
>george
>
>package winls.dbdata.pljava;
>
>import java.sql.*;
>import java.util.logging.*;
>import org.postgresql.pljava.*;
>import java.util.Date;
>/**
> *
> * @author user
> */
>public class DateFunc {
>
> public static void getBirthDate(){
> try {
> Statement m_statement =
>DriverManager.getConnection("jdbc:default:connection").createStatement();
> String query="select birthdate from customers where custid
>=385 ";
> ResultSet rs=m_statement.executeQuery(query);
> if(rs != null)
> while(rs.next()){
> Logger.getAnonymousLogger().info("Birthdate
>"+rs.getDate(1));
> }
> }
> catch (Exception e){
> Logger.getAnonymousLogger().info(""+e.getMessage());
> }
> }
>
>
>}
>
>_______________________________________________
>Pljava-dev mailing list
>Pljava-dev at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>
view thread (3+ messages) latest in thread
Message-ID: <thhal-0mJXaA8vb77Q90ldIzVVlM69mQSE96J@mailblocks.com>
Permalink: ../thhal-0mJXaA8vb77Q90ldIzVVlM69mQSE96J@mailblocks.com/
Also on: postgresql.org/message-id/thhal-0mJXaA8vb77Q90ldIzVVlM69mQSE96J@mailblocks.com
reply
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: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] date handling...
In-Reply-To: <thhal-0mJXaA8vb77Q90ldIzVVlM69mQSE96J@mailblocks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox