Time Column changes time when exporting or editing!
Nobody has claimed this yet.
- Dominant language
- JavaScript
- Stars
- 214
- Forks
- 52
- Avg merge
- 1d 10h
- Merged PRs (30d)
- 82
Description
Steps to reproduce
Hi,
we have a table that uses a column of the type "date & time" set to only "time".
When exporting the table to CSV all the entered times do have a wrong value. the are all offset by 2 hours.
I guess, that there is an issue that the time is stored with a time zone (or without one) and the export uses a different time zone (e.g. server time zone).
Expected behavior
i want that the export shows the exact same time as in the tables app.
Actual behavior
all exported times to have a 2h offset.
Tables app version
2.2.0
Browser
Chrome
Client operating system
Windows
Operating system
No response
Web server
None
PHP engine version
None
Database
None
Additional info
No response
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No file or test is named. Reproduce the issue in Tables app 2.2.0 with a time-only date-time column, compare the displayed value with the CSV export and editing behavior, and trace the date-time and CSV export entry points. Done means exported and edited values match the exact time shown in the table without a two-hour offset.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript
- Domain
- full-stack
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 64/100