Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
What is an ojdbc14 jar ? Dave Cramer dave.cramer(at)credativ(dot)cahttp://www.credativ.caOn Thu, Dec 5, 2013 at 2:33 AM, pravdas <pdas77@gmail.com> wrote: JVM Timezone details :India Standard TimeAsia/Calcutta019800000 DB Timezone details :Central Standard TimeAmerica/Chicago3600000-21600000 String sql = "select systimestamp as base from dual"; ..... PreparedStatement stmt = con.prepareStatement(sql); ResultSet rs = stmt.executeQuery(); while(rs.next()) { System.out.println(rs.getTimestamp("base")); System.out.println(rs.getString("base")); } Test-1: I tested using ojdbc14.jar 10.1.0.3.0 with, it works as expected printing the db time Output: 2013-12-05 01:23:57.141583 2013-12-5 1.23.57.141583000 -6:0 Test-2: I tested using ojdbc5.jar & ojdbc6.jar 11.2.0.3.0 with, getTimestamp print local time where as getString prints db time. Output: 2013-12-05 12:57:54.3508 2013-12-05 01:27:54.3508 -6:00 Please suggest what is wrong with Test-2 ojdbc driver version 11.2.0.3.0 where the getTimestamp() prints local time. My application expect the db time like Test-1 in the getTimestamp(). -- View this message in context: http://postgresql.1045698.n5.nabble.com/Timestamp-issue-from-ojdbc5-ojdbc6-tp5781795.html Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com. -- Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-jdbc
JVM Timezone details :India Standard TimeAsia/Calcutta019800000 DB Timezone details :Central Standard TimeAmerica/Chicago3600000-21600000 String sql = "select systimestamp as base from dual"; ..... PreparedStatement stmt = con.prepareStatement(sql); ResultSet rs = stmt.executeQuery(); while(rs.next()) { System.out.println(rs.getTimestamp("base")); System.out.println(rs.getString("base")); } Test-1: I tested using ojdbc14.jar 10.1.0.3.0 with, it works as expected printing the db time Output: 2013-12-05 01:23:57.141583 2013-12-5 1.23.57.141583000 -6:0 Test-2: I tested using ojdbc5.jar & ojdbc6.jar 11.2.0.3.0 with, getTimestamp print local time where as getString prints db time. Output: 2013-12-05 12:57:54.3508 2013-12-05 01:27:54.3508 -6:00 Please suggest what is wrong with Test-2 ojdbc driver version 11.2.0.3.0 where the getTimestamp() prints local time. My application expect the db time like Test-1 in the getTimestamp(). -- View this message in context: http://postgresql.1045698.n5.nabble.com/Timestamp-issue-from-ojdbc5-ojdbc6-tp5781795.html Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com. -- Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-jdbc
В списке pgsql-jdbc по дате отправления: