Java (new Date()).getTime() - java.util.Timestamp("select timestamp from dual").getTime() ???

From: Joerg Weule <jweule_at_arcor.de>
Date: Tue, 22 May 2007 22:34:50 +0200
Message-ID: <465353e9$0$10183$9b4e6d93@newsspool4.arcor-online.net>

Hello,

I tried to retrieve a timestamp from my database independent from the local TZ environment variable. The ResultSet.getTimestamp(...).getTime() method should return the number of seconds after "1.1.1970 GMT" like (new Date()).getTime() .

Is there any timestamp (current, local, sys, ...) to get the correct time?

Thanks in advance

Jörg

---

export TZ=...

run :

PreparedStatement s = c.prepareStatement(

"SELECT ?????????? FROM dual");

ResultSet rs = s.executeQuery();
rs.next();
t3 = rs.getTimestamp(1,java.util.Calendar.getInstance()); System.out.println(

"Timestamp-Error:"

    +rs.getTimestamp(1).getTime()-(new Date().getTime()); rs.close() ;
s.close() ; Received on Tue May 22 2007 - 15:34:50 CDT