I get different results when I run a transformation in Copenhagen (timezone GMT+1) and Kiev (timezone GMT+2) respectively. I have narrowed the cause down to the value of system variable "start date range (Transformation)" in cases where log table is empty.
When I run in Copenhagen "start date range (Transformation)" is 1900/01/01 00:00:00.000 but when run in Kiev it is 1900/01/01 01:00:00.000. A difference of one hour.
I have noticed that changing Date & Time settings in Windows affects the value (after restarting Kettle). I have also tried different databases in different timezones but it does not seem to matter.
Can anyone help me explain why this is happening?
Kettle version is 3.1.0 and DB connections are Oracle/JDBC.