what is the format of column timestamp_log?

[dh]

What is the key to reading/decoding column timestamp_log in table dadabik_logs? Does it translate uniquely to a calendar date?

Thank you.




---
You are using DaDaBIK version 7.3.3 enterprise, installed on 11-11-2016, the last version of DaDaBIK is released on --

You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.

PHP Version: 7.0.28

mysql version: 5.6.38

Web server: Apache

Client: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_3) AppleWebKit/604.5.6 (KHTML, like Gecko) Version/11.0.3 Safari/604.5.6

 

[eugenio]

Hello,
it's a timestamp, generated by the PHP function time(), which "Returns the current time measured in the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT).". See:

http://php.net/manual/en/function.time.php

for details.

On mysql you can translate it using from_unixtime, e.g.

SELECT from_unixtime (timestamp_log) FROM `dadabik_logs`

Best,