[jKodar]

When i am running select SESSIONTIMEZONE FROM dual or oracle client then its working fine and giving me result as +05:30.

But when i am executing same query in java code then i am getting the result as +00:00 on same database.

pstmt = con.prepareStatement("SELECT SESSIONTIMEZONE FROM dual");
pstmt.execute();
rs = pstmt.getResultSet();
if (rs.next()) {
String timeZoneInfo = rs.getString(1);
}

now i get timeZoneInfo as +00:00 as it should be +5:30.

Kindly reply ASAP.
Thanks in advance.