Hello NiFi Developers, Environment: - NiFi Version: 2.8.0 - OS: Windows - MySQL Version: 8.0+ - Processor: CaptureChangeMySQL Problem description: 1. When reading binlog with CaptureChangeMySQL, datetime fields have +8 hour timezone offset. 2. Original MySQL data: 2025-03-12 10:25:24.552591(DATETIME(6)) 3. NiFi output format: Wed Mar 12 18:25:24 GMT+08:00 2025 It loses microseconds and has wrong timezone. Questions:
1. Why microsecond precision from DATETIME(6) binlog is discarded? 2. How can i get the value "yyyy-MM-dd HH:mm:ss.fff" 3. Is there an official configuration guide for datetime timezone handling in this processor? Thank you very much for your help.
