zendesk / maxwell

Maxwell's daemon, a mysql-to-json kafka producer
https://maxwells-daemon.io/
Other
4.05k stars 1.01k forks source link

maxwell uses utc to convert timestamp, but not converting datetime. How can we convert datetime by utc as well? #2085

Open jackjoesh opened 9 months ago

jackjoesh commented 9 months ago

I support the rule which converts timestamp column by utc in maxwell. But maxwell doesn't convert the datetime column by utc due to the datetime havingn't the timezone. So there will be a different output between the timestamp and the datetime, how can we convert the datetime by utc as well? Do you suggest some official solution or recommendation extending way? For example ,we can get the timezone of mysql and convert it by filter.js? thanks