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

Answer Copied

The timestamp is in Unix Epoch time format which is under UTC timezone. We have provided examples of database commands to convert the timestamp format for various database vendors.

Possible solutions Copied

• Solution Root Cause 1:

Database Commands Copied

Please refer to the Gateway database documentation, and look for sections named Handling Timestamps.

• Solution Root Cause 2:

Linux Commands Copied

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 Copied

$ 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 Copied

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

Related articles Copied

• Geneos database documentation