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:

 
1 comment
Comment actions Permalink

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)

0

Please sign in to leave a comment.