If you have a string that represents a point in time, there are a couple ways that you can convert it to a PostgreSQL timestamptz value. If the string is in ISO 8601 format, then it can be simply cast ...
Convert date in MS Excel to integer MySQL or Unix timestamp. Converting data into different data formats and platforms can be complicated if we do not know how to do it easily, and especially quickly.