Timestamp format

Developers Central
1

I’ve generated a timestamp with Postgres via PHP:

1685539197953

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?

2

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