Answer:

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:

• Solution Root Cause 1:

Database Commands

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

• Solution Root Cause 2:

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

Related articles:

• Geneos database documentation

If you need further help:

• Please contact our support team via the chat service box on any of our websites or raise a support request.
  
• Make sure you provide us with:
  • Background of the issue or request.
  • Use cases, requirements, business impact, etc.
  • Encountered error messages.
  • Log files or diagnostic files.
  • Screenshots.
  • And other important information relevant to your inquiry.