GitHub user hansva added a comment to the discussion: BUG : Apache Hop unable 
to convert strings to date (for DST change 9 Mar 2025 2am to 3am)

There is a difference between what you see in the UI and the actual data.
The actual data is UTC (as you have provided a timezone) if you are writing to 
a database field with timezone support it will write the data with the 
timezone. 
If the database does not have timezone support and it is a regular date field 
you can use a select values transform and in the metadata tab change the Date 
Time Zone to UTC.

![image](https://github.com/user-attachments/assets/0d3ba463-00fd-458b-803c-17e2110be148)

Alternatively, you can add the following parameter to the Hop startup commands 
to change the application time zone.
-Duser.timezone=UTC

GitHub link: 
https://github.com/apache/hop/discussions/5033#discussioncomment-12548765

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to