alibaba / alibaba/DataX

postgres同步到mysql timestamp(6)类型字段精度丢失

Open
#2,359 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
17.4k
Forks
5.7k
PR merge metrics
No merged PRs in 30d

Description

postgres 字段值:2026-06-24 14:00:26.025671
mysql 字段值:2026-06-24 14:00:26.025000

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce the PostgreSQL-to-MySQL sync using a timestamp(6) value such as 2026-06-24 14:00:26.025671, then trace the Java connector path responsible for timestamp conversion. Done means the MySQL value retains all six fractional digits instead of becoming 2026-06-24 14:00:26.025000.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql, postgresql
Domain
data-engineering, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.