in mysql to mysql connection datetime columns are ...
# ask-community-for-troubleshooting
d
in mysql to mysql connection datetime columns are replicated as string. Ex: '2018-02-09 094500' is replicated as '2018-02-09T064500.000000Z'. Is there a solution in airbyte for this?
👀 1
m
@Doğacan Düğmeci thanks for this question, I added to our discourse: https://discuss.airbyte.io/t/source-mysql-datetime-column-is-replicated-with-microseconds/260/2
Hope the answer help you.
d
you mean then I have to transform back to datetime by myself?
m
This is a solution, you can export the normalization project and edit to your needs. Airbyte create normalization as more generic as possible.
👍 1
d
sorry (that I'm not a software engineer) where and how should I edit exactly (on a docker deployment)?
h