Page 1 of 1

Using JDBC connector to POSTGRES , current TS is wrong

Posted: Fri Mar 24, 2017 4:01 pm
by ep_datastage
The time changed recently to day saving time, but the current_timestamp received when running a job in DS is still 1 hour behind.

This is only an issue on the JDBC connection to POSTGRES. Additionally, when I run the same query directly against the POSTGRES db, I get the correct time.

Posted: Fri Mar 24, 2017 6:16 pm
by chulett
Perhaps you need something like this IBM Time Zone Update Utility for Java but I would involve support regardless.