I'm trying to convert epoch data in one column (timestamp_epoch) to a legitimate timestamp in another column (timestamp) for every record in a table. In reading the PostgreSQL Documentation it appears I can do this using the to_timestamp() function, but I get an error indicating this function does not exist.
UPDATE table
SET timestamp = to_timestamp(timestamp_epoch) AT TIME ZONE 'EST'
WHERE timestamp IS NULL;
Server is a PostgreSQL 12.1 and I'm using pgAdmin4 to run the query. When the query runs, I get an error indicating the function doesn't exist and that I might need to add explicit type casts... for which I'm lost on how to properly do if that is indeed needed.
ERROR: function to_timestamp(text) does not exist
LINE 2: SET timestamp = to_timestamp(timestamp_epoch)
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
SQL state: 42883
Character: 56
Any help on converting the epoch data in one column to a legitimate timestamp in another column is appreciated.
Thanks!