Question

Sql Server JDBC is reading datetime fields incorrectly

  • 9 October 2022
  • 2 replies
  • 51 views

For suppose if I have datetime as 2022-09-30 07:50:24 in SQL Server DB then it is translating it to 2022-09-30 06:50:24 in SQL SERVER CDC Client. One hour behind in Streamsets SQL SERVER CDC client with what we have in SQL SERVER DB. Could you please help us on how to fix it? As we need the same data without any difference to be transferred to destination. 

 

Thanks!


2 replies

Userlevel 2
Badge

Hi @rayyan143786,

This is likely a timezone issue, make sure all the systems have coherent timezones, I will specially check that the DB and the server where it is running are aligned.

Hello Alex,

 

Thank you!

 

We have different source DB’S and they are in different zones but when data goes through Streamsets data collector it is showing one hour difference irrespective of source DB timezone. Our data collectors need to be in UTC timezone?

Reply