10000 Patch from Barry Lind to correctly decode time zones in timestamp res… · danielcode/postgres@0b471cc · GitHub
[go: up one dir, main page]

Skip to content

Commit 0b471cc

Browse files
author
Thomas G. Lockhart
committed
Patch from Barry Lind to correctly decode time zones in timestamp results.
Without patch, the time zone field is ignored and the returned time is not correct. Already applied to the development tree...
1 parent 041c752 commit 0b471cc

File tree

1 file changed

+4
-4
lines changed

1 file changed

+4
-4
lines changed

src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -499,13 +499,13 @@ public Timestamp getTimestamp(int columnIndex) throws SQLException
499499
// could optimize this a tad to remove too many object creations...
500500
SimpleDateFormat df = null;
501501

502-
if (s.length()>23 && subsecond) {
502+
if (sbuf.length()>23 && subsecond) {
503503
df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSSzzzzzzzzz");
504-
} else if (s.length()>23 && !subsecond) {
504+
} else if (sbuf.length()>23 && !subsecond) {
505505
df = new SimpleDateFormat("yyyy-MM-dd HH:mm:sszzzzzzzzz");
506-
} else if (s.length()>10 && subsecond) {
506+
} else if (sbuf.length()>10 && subsecond) {
507507
df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");
508-
} else if (s.length()>10 && !subsecond) {
508+
} else if (sbuf.length()>10 && !subsecond) {
509509
df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
510510
} else {
511511
df = new SimpleDateFormat("yyyy-MM-dd");

0 commit comments

Comments
 (0)
0