agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] date handling...
Date: 13 Aug 2005 23:45:17 -0500
Message-ID: <1123994718.4039.9.camel@sat1> (raw)

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());
        }
    } 
    
    
}

view thread (3+ messages)  latest in thread

Message-ID: <1123994718.4039.9.camel@sat1>
Permalink:  ../1123994718.4039.9.camel@sat1/
Also on:    postgresql.org/message-id/1123994718.4039.9.camel@sat1

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: <1123994718.4039.9.camel@sat1>

* 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