admin管理员组

文章数量:1288068

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?

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?

  • date
  • dbeaver
  • mysql-8.0
Share Improve this question edited Feb 22 at 19:07 Mureinik 312k54 gold badges358 silver badges391 bronze badges asked Feb 22 at 16:49 mstdmstdmstdmstd 3,13522 gold badges86 silver badges187 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 2

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

本文标签： dateCan I see timestamp in dbeaver in human readable formatStack Overflow

版权声明：本文标题：date - Can I see timestamp in dbeaver in human readable format? - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1741333947a2372929.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。