[opencms-dev] mySql query

[Christoph P. Kukulies]

I'm trying to quickly do some excerpt from the opencms database and
thought that it would be faster if I do a

mysql> use opencms
mysql> select user_name,user_lastlogin from cms_users;

But the stored date in Mysql is a timestamp (don't even know it that is
down by OpenCms as a Unix timestamp or a Mysql timestamp).

So does anyone know, how to convert the last_login timestamp to a human
readable DATE in the above SQL-statement?


OTOH I wouldn't mind about a OpenCMS code snippet that loops over all
users and prints the appropriate information.

Thanks.
--
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de