https://linen.dev logo
#ask-community-for-troubleshooting
Title
# ask-community-for-troubleshooting
d

Doğacan Düğmeci

03/11/2022, 1:16 PM
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

Marcos Marx (Airbyte)

03/11/2022, 5:53 PM
@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

Doğacan Düğmeci

03/11/2022, 7:33 PM
you mean then I have to transform back to datetime by myself?
m

Marcos Marx (Airbyte)

03/11/2022, 7:35 PM
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

Doğacan Düğmeci

03/12/2022, 3:09 AM
sorry (that I'm not a software engineer) where and how should I edit exactly (on a docker deployment)?
h

Harshith (Airbyte)

03/14/2022, 8:57 AM