Actually, it does have to be with PDI.
One way of setting it, it's going to your spoon.sh
file, and adding this argument to the java options.
In my case, in Ubuntu, I added this "
" at the end of the "
" variable declaration.
: This will set the timezone for all of your PDI executions. Every single Timezone / Date you retrieve from your database or files will be converted to that timezone unless you do some additional timezone conversion within PDI.EDIT:
For the spoon.bat
file in windows, you need to add it like this: (appending a space and the extra argument between "")