Add datetime/date view in the data table for sqlite timestamp columns
- Dominant language
- Java
- Stars
- 51.8k
- Forks
- 4.4k
- Avg merge
- 3d 8h
- Merged PRs (30d)
- 188
Description
**Is your feature request related to a problem? Please describe.**
Timestamp columns of tables of sqlite databases are only shown as unix time (large number) and one cannot change/set the "View/Format" to datetime, which is possible for other database systems.
**Describe the solution you'd like**
Timestamp columns of sqlite databases should be automatically recognized as timestamps and then displayed according to the user settings in Preferences>Editors>Data Editor>Data Formats
**Describe alternatives you've considered**
I have tried to manually changing the format but the options do not offer datetime. As a workaround one can use the sqlite functions datetime and date, but this is quite inefficient.
**Additional context**
Version 22.2.2.202210092258
Contributor guide
Assessment
This issue has not been assessed yet.