Display UNIX Timestamps to human readable format
I'm working with various projects which store UNIX timestamps in the database (e.g.: 1651567166).
It's consuming some time to copy the value and use a 3rd party service to convert it...
Is there a faster way to display these timestamps to a human readable format (e.g. 2022-05-03 08:39:26.000000 +00:00) in the Database module?
Example:
Original data:
Formatted data:
Please sign in to leave a comment.
Hi there,
AFAIK there is none.
I have found these:
These both tickets are marked as duplicate of https://youtrack.jetbrains.com/issue/DBE-1084 -- to have an API to allow dynamically represent the cell value (e.g. store as an int but display and input as a DateTime etc)