dadabik_logs

[juergen_mueller]

Hi, Eugenio

Is it possible to extract the information given in the timestamp_log (dadabik_logs) into a human readable form? I want use it for statistical reasons.

Thanks

Jürgen

 

[bkim]

You can use this site: http://www.unixtimestamp.com/index.php

Or if you need to convert on excel,

value / 86400 + "1/1/1970"

and view as date time.

 

[eugenio]

Hello,
you can also use a query:
[pre]
SELECT *, FROM_UNIXTIME(timestamp_log) FROM dadabik_logs
[/pre]

show all the fields plus an additional column which represents the timestamp converted in date-time format.

 

[juergen_mueller]

Hi both

Thanks for the hints, I'll try.

Cheers

J

 

[juergen_mueller]

Hi, Eugenio

Works exactly as I needed. Thanks, Juergen

 

[eugenio]

You are welcome.

Best,