Open
Description
What was unclear or otherwise insufficient?
Users often encounter difficulty dealing with timezones. We could add some advice on this topic to the docs:
- Explain how timezone information is carried between TypeORM and database fields, with conversion to/from string and Date types
- Importance of matching the timezone between node and database servers
- How to set the
TZenvironment variable when launching node process - How to change the timezone in different database engines
Recommended Fix
Could be an FAQ entry, or a separate page if the answer is long enough.
Additional Context
Related:
- MSSQL - Incorrect datetime is returned from entity #11491
- mysql DATE type returned incorrectly when server and db use different timezones #9790
Are you willing to resolve this issue by submitting a Pull Request?
No, I don’t have the time and I’m okay to wait for the community / maintainers to resolve this issue.