Bug #651: Time difference of 30 in while reading in timestamp

Ravishankar Rajagopalan (rravishankar(at)sify(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Time difference of 30 in while reading in timestamp

Long Description
I am using Java 1.3.1 and Postgres 7.1.2 and am writing timestamp without zone info to the database using JDBC (my zone is IST or +5:30GMT). I find that there is always a time difference of 30 minutes when i read from the database.

When i query the postgres database from the SQL prompt, the time is as i had written it. But when i read it from the database into my java code it is more exactly by 30 mins.

I have pasted the code herewith (in which i have used a 30 min offset) . Any solution for this ?

Sample Code
String databaseURL = "jdbc:postgresql:am";

Timestamp ts_ls_dn =null, ts_current_time=null;
long tld =0, tct=0, diff = 0, tot_fails=0;
int rec_fails=0;
boolean fatal_err = false;

try{
Class.forName("org.postgresql.Driver");

Connection conn1 = DriverManager.getConnection(databaseURL,"abc","");

PreparedStatement p = conn1.prepareStatement("select last_dn_time from mon where name=?");
p.setInt(1, serv_id);

ResultSet rs = p.executeQuery();
rs.next();
ts_ls_dn = rs.getTimestamp("last_dn_time");

ts_current_time = new Timestamp(System.currentTimeMillis());
tld = ts_ls_dn.getTime();
tct = ts_current_time.getTime();
diff = ((tct-tld)/60000)+30;//Time in minutes. 30 added to makeup for error

}
catch (Exception x){
x.printStackTrace();
}

No file was uploaded with this report