Timestamp format

I’ve generated a timestamp with Postgres via PHP:


However the EpochToDate() formula won’t calculate this correctly unless I truncate it to the first 10 characters.

Is there something important I’m missing by doing so?

I think the issue is that your value is in milliseconds, and EpochToDate expects seconds. The documentation describes the formula’s input as:

The number of seconds since Jan 1st, 1970

However other systems return the timestamp in milliseconds, and that is likely what Postgres is doing.

1 Like