What is the format of the timestamp column in ITRS Geneos database?

Database Commands

Users can refer to the Gateway Databases documentation, and look for sections named Handling Timestamps. We have provided examples of database commands to convert the timestamp format for various database vendors.

Linux Commands

For Linux users, the "date" command can be handy to provide date conversion. Please refer to the Linux man pages ("man date") for more information. We have used +u and +%s switches as examples below.

From Human Readable Date to Epoch

$ date -u -d "2018-12-25 12:34:56"
Tue Dec 25 12:34:56 UTC 2018
$ date -u -d "2018-12-25 12:34:56" +%s
1545741296

From Epoch to Human Readable Date

$ date -u -d @1545741296
Tue Dec 25 12:34:56 UTC 2018