Commit0b471cc

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 parent041c752 commit0b471ccCopy full SHA for 0b471cc

File tree

-4

lines changed

-4

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -499,13 +499,13 @@ public Timestamp getTimestamp(int columnIndex) throws SQLException`
`499`	`499`	`// could optimize this a tad to remove too many object creations...`
`500`	`500`	`SimpleDateFormatdf =null;`
`501`	`501`
`502`		`-if (s.length()>23 &&subsecond) {`
	`502`	`+if (sbuf.length()>23 &&subsecond) {`
`503`	`503`	`df =newSimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSSzzzzzzzzz");`
`504`		`- }elseif (s.length()>23 && !subsecond) {`
	`504`	`+ }elseif (sbuf.length()>23 && !subsecond) {`
`505`	`505`	`df =newSimpleDateFormat("yyyy-MM-dd HH:mm:sszzzzzzzzz");`
`506`		`- }elseif (s.length()>10 &&subsecond) {`
	`506`	`+ }elseif (sbuf.length()>10 &&subsecond) {`
`507`	`507`	`df =newSimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");`
`508`		`- }elseif (s.length()>10 && !subsecond) {`
	`508`	`+ }elseif (sbuf.length()>10 && !subsecond) {`
`509`	`509`	`df =newSimpleDateFormat("yyyy-MM-dd HH:mm:ss");`
`510`	`510`	`}else {`
`511`	`511`	`df =newSimpleDateFormat("yyyy-MM-dd");`

Comments

(0)