dbeaver / dbeaver/dbeaver

Add datetime/date view in the data table for sqlite timestamp columns

Open
#18,102 3 comments 0 reactions 1 assignee Claimed by @Destrolaric View on GitHub
x:sqlite xf:metadata
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.