Dev Tools · 1h ago
NocoBase timestamp bug: MySQL vs PostgreSQL timezone handling exposed
NocoBase users report timestamps shifted by their timezone offset. Testing shows MySQL's DATETIME type stores wall-clock times without offset, while PostgreSQL's timestamptz stores absolute instants. Changing the server timezone on MySQL shifts the meaning of stored timestamps by the offset difference.
Meridian48 take
This is a classic database gotcha that NocoBase should document clearly, not a bug — but the confusion highlights how MySQL's lack of timezone-aware types can silently corrupt data for multi-timezone apps.
Read the full reporting
NocoBase and the mystery of the shifted timestamps: MySQL vs PostgreSQL, measured →
DEV Community
nocobasetimestamp-bug