datedbeavermysql-8.0

Can I see timestamp in dbeaver in human readable format?

In MySQL 8 app table sessions has date defined as last_activity int NOT NULL.

I see timestamp in dbeaver 24 as an integer value and I wonder if there is a way to format this date in human-readable format?

Solution

  • Seems like you're storing a unix timestamp. If that's the case, you can use from_unixtime to convert it to human-readable datetime:

    SELECT FROM_UNIXTIME(last_activity)
FROM   sessions