Timezone issue in NocoDB after PostgreSQL migration

[tanat0]

Hi,

I'm experiencing a timezone issue in the NocoDB web interface after migrating my PostgreSQL database.

Previously, when using the old setup, the CreatedAt timestamps appeared in UTC+3. Now, after the migration, they appear in UTC.

Here’s some context:

Migration was from one PostgreSQL instance to another on the same server

Timezone settings in both PostgreSQL instances are the same

NocoDB version: 0.262.5

Previously, I used docker-compose for both NocoDB and the database

Now, I use docker-compose only for NocoDB, and the database runs outside the container

Do you know what might be causing this difference and how I can fix it?

Thanks in advance!

[o1lab]

FYI, it must be your timezone settings - pls double check. The value stored in dB is always utc and While displaying in UI its always your local time.

[tanat0]

Thanks for the reply.

I checked the database — the system fields do store UTC, as expected.
However, the UI is also showing UTC time, not my local time.

When I add a new row through the UI, both the database and the UI show the same UTC timestamp.

I also checked the browser time via the console — it's correctly set to my local time (UTC+3).

In the nocodb container there is also UTC time if it's important

Any ideas what else I could check?

[olavarriaga]

Hi,

I'm having the same issues and the time-zone of my browser is fine.

Did add the TZ variable to both Postgres and Noco and still having issues with Dates.

[Auxxxxx]

Same issue here.
Migrated from a PostgreSQL database to another PostgreSQL database.
NocoDB version: 0.263.4
Something is definitely wrong with displaying timestamps.
In the screenshot I have tried to group the entries by the "created_at" field, NocoDB shows contradicting data where the value of the field is the same as in the database and does not apply the time zone of the browser, while the value in the "Group" window does apply the time zone.
The value is stored as 2025-05-27 14:24 (timestamp) in PostgreSQL and should be displayed as 2025-05-27 17:24 in NocoDB.
In the browser the time zone is 'GMT+3'.