π Reproduction steps
- In Appwrite Console, go to Databases β your database β Tables.
- Open a table that has a
datetime column (e.g. startAt).
- Create a row with
startAt = 2026/01/01, 00:00:00.000 (Japan / UTC+9).
- In the rows grid, click the three-dots menu (β―) on the row and select Update.
- Change another field (do NOT modify
startAt) and click Update.
- Observe that
startAt has shifted by +9 hours.
- Repeat update β datetime shifts by +9 hours every time.
π Expected behavior
It should preserve existing datetime values when a row is updated from the Console.
Datetime fields should not be modified unless the user explicitly edits them.
The Console should clearly indicate how datetime values are interpreted and saved.
π Actual Behavior
When a row is updated from the Console, datetime fields are re-submitted even if they were not modified.
The Console appears to send the datetime value displayed in local timezone and save it as UTC, which results in a +9 hour shift in Japan (UTC+9).
As a result, datetime values change on every update, even when the user does not edit them.
π² Appwrite version
Appwrite Cloud
π» Operating system
MacOS
π§± Your Environment
- Appwrite Cloud
- API Endpoint: https://sgp.cloud.appwrite.io/v1
- Browser: Google Chrome on macOS Version 143.0.7499.193 (Official Build) (arm64)
- Region: Japan (UTC+9)
π Have you spent some time to check if this issue has been raised before?
π’ Have you read the Code of Conduct?
π Reproduction steps
datetimecolumn (e.g.startAt).startAt = 2026/01/01, 00:00:00.000(Japan / UTC+9).startAt) and click Update.startAthas shifted by +9 hours.π Expected behavior
It should preserve existing datetime values when a row is updated from the Console.
Datetime fields should not be modified unless the user explicitly edits them.
The Console should clearly indicate how datetime values are interpreted and saved.
π Actual Behavior
When a row is updated from the Console, datetime fields are re-submitted even if they were not modified.
The Console appears to send the datetime value displayed in local timezone and save it as UTC, which results in a +9 hour shift in Japan (UTC+9).
As a result, datetime values change on every update, even when the user does not edit them.
π² Appwrite version
Appwrite Cloud
π» Operating system
MacOS
π§± Your Environment
π Have you spent some time to check if this issue has been raised before?
π’ Have you read the Code of Conduct?