GitHub user ossDataEngineer added a comment to the discussion: BUG : Apache Hop unable to convert strings to date (for DST change 9 Mar 2025 2am to 3am)
Hello @hansva, I used the format string 'yyyy-MM-dd'T'HH:mm:ss.SSS' to parse this date - which resulted in failure. When I use format 'yyyy-MM-dd'T'HH:mm:ss.SSSZ' Hop converts the original UTC date to datetime with appropriate timezone. My goal is to parse UTC date and save it in UTC format in target database tables. Using 'yyyy-MM-dd'T'HH:mm:ss.SSSZ' converts the original UTC datetime into localised datetime, which I want to avoid GitHub link: https://github.com/apache/hop/discussions/5033#discussioncomment-12544352 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
