SQL cast

The general syntax for casting a value into another is

SELECT CAST(date AS TIMESTAMP) FROM table

In PostgreSQL we can use the CAST operator:

SELECT date::TIMESTAMP FROM table