From: | Scott Carr <kscarr73(at)gmail(dot)com> |
---|---|
To: | Dave Cramer <pg(at)fastcrypt(dot)com>, pravdas <pdas77(at)gmail(dot)com> |
Cc: | List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Timestamp issue from ojdbc5 & ojdbc6 |
Date: | 2013-12-06 21:25:58 |
Message-ID: | 52A240E6.8000409@gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
ojdbc14 is a jar from Oracle.
(Hey I actually answered something on the list. ;-)
On 12/05/2013 10:56 AM, Dave Cramer wrote:
> What is an ojdbc14 jar ?
>
> Dave Cramer
>
> dave.cramer(at)credativ(dot)ca
> http://www.credativ.ca
>
>
> On Thu, Dec 5, 2013 at 2:33 AM, pravdas <pdas77(at)gmail(dot)com
> <mailto:pdas77(at)gmail(dot)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(at)postgresql(dot)org
> <mailto:pgsql-jdbc(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Radtke | 2013-12-06 22:48:05 | Service principal, GSSAPI and JDBC connection issue |
Previous Message | Dave Cramer | 2013-12-05 20:43:07 | Re: setQueryTimeout woes |