IBM Support

The conversion between Unix timestamp and datetime in PostgreSQL

Question & Answer


Question

Unix timestamp is widely used in computer applications, one of the examples is Platform LSF lsb.stream file in which HPC lsfeventsloader reads regularly. Unix timestamp is not human-readable, so how do we convert between Unix timestamp and datetime in PostgreSQL?

[{"Product":{"code":"SSJSMF","label":"Platform Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSZTRM","label":"IBM Spectrum LSF Analytics Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":null,"Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
Platform Analytics

Software version:
8.3.0

Document number:
677847

Modified date:
17 June 2018

UID

isg3T1019871