How to understand the values in column TimeStamp ()... The date and time? What is it? Thanks

Username
Url
TimeStamp()

abrikos
/pg/admin/plugins/
1268436116

abrikos
/pg/dbvalidate/
1268436146

abrikos
/pg/profile/abrikos
1268436180

@Abrikos its a Unix TimeStamp

I dont know how it works. But you can use this online converter to make it human readable.

http://unixtime-converter.com/

From the timestamp u gave above, 1268436116 --->   Sat Mar 13 2010 06:21:56 GMT+0700

Unix time - Wikipedia
Unix time, or POSIX time, is a system for describing points in time, defined as the number of seconds elapsed since midnight Coordinated Universal Time (UTC) of January 1, 1970

I understand, nice... Thanks...

I choose the timestamp and not another datetime formats because it's the most easy way to make mathematical operations. To convert Timestamp in date mm/dd/yyy, you can make a new cell with:

= 25569 + $C1 / 86400

($C1 is the cell whit the timestamp number; 25569 is 1/1/1970 in general format and 86400 is the seconds in a day).

Press with right button over the new cell, choose "cell format" and "date" and extend this new cell to the all rows (with copy/paste or dragging from the downright corner of the cell).

You can make another column but choosing "time" in "cell format" options, and can see the time.

If this explanation not is clear please ask again.

Thanks

Its better in datetime formats in my opinion.

Ok, I updated the plugin, in the new version, the datetime row contains the information in general format. Thankyou elHayaze.