Incorrect SQL time retrieved

[WWong1683187644]

Hi All,

I am facing a weird issue, but i have no idea what should i check to fix the problem.

I am using Talend job to execute the store procedure in Redshift together with a parameter getdate(),

But the result comes out is not in the Redshift timezone, it is GMT+0 instead.

I notice that difference when i run the select getdate() in redshift directly, in my case is GMT+8.

My question here is how come the result from talend and redshift can be different?

It looks fine to me, no code or advance setting that purposely change the timezone, is there anything else i can check to solve this problem?

[WWong1683187644 · Accepted solution]

I found the root cause already, it is depending on the driver version of the redshift connection component.

V1 will give the datetime in GMT+0,

V2 will give the datetime in the server timezone

I also find this info online for your reference:

https://repost.aws/questions/QUzxhtdeEJSqKlrnHMilbIew/redshift-jdbc-driver-getdate-returns-time-in-server-time-zone-instead-of-in-utcd