Using JDBC connector to POSTGRES , current TS is wrong

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
ep_datastage
Participant
Posts: 24
Joined: Wed Apr 16, 2014 11:11 am
Location: United States

Using JDBC connector to POSTGRES , current TS is wrong

Post 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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Perhaps you need something like this IBM Time Zone Update Utility for Java but I would involve support regardless.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply