Bug: date fields are displaying incorrectly in v1.9.40

English Forum
1

Hi
After updating to NocoBase v1.9.40, I’ve noticed that some date fields are displaying incorrectly. For example, in the DOB field, the record in the external database (MariaDB v10.6.22) shows 2017-07-26, but in the table block UI it displays as 25-07-2017.

This issue seems to happen randomly across all date fields in any UI block (table, details, list). Has anyone else experienced this issue?

Update: The internal DB (MariaDB v11.4.9) working fine without any issue.

Here are the screenshots of Nocobase UI and database

image
image519×849 27.2 KB

Database
image

Regards
Nat

2

Please check the field settings.

image
image635×691 40.2 KB

3

The date format is correct. As you can see from the above screenshots. Some records have the incorrect date display, not all of them.

image

DB field setting

date-setting
date-setting846×795 42 KB

4

I misunderstood. What type of field is it? Is the environment variable TZ= set?

5

Please see the above post, I just upload a screenshot.

6

All date fields in the DB have the same type.

date-setting2
date-setting2881×55 4.22 KB

7

Is the NocoBase environment variable TZ set?

8 
  - TZ=Pacific/Auckland
9

Here is another example from another table.

table_1
table_1590×736 42 KB

DB
db_1

10

I have now confirmed with my staff that they noticed the date changes last week but did not inform me at the time.

Because of this, I initially thought the issue occurred after updating to v1.9.40. However, it now appears that the problem may have started before the update.