How do you convert a timestamp to a date in PG?

In PostgreSQL, the to_timestamp function can be used to convert a timestamp to a date. Here is an example:

SELECT to_timestamp(1618322387) AS date;

In this example, 1618322387 is a timestamp which can be converted to a date using the to_timestamp function. You can adjust the value of the timestamp as needed to obtain different date values.