Postgresql Convert Timestamp To Date

• Yes, we have many ways to convert Timestamp to date by using this DATE() function in PostgreSQL server as we can obtain the date from the Timestamp.

For example:

SELECT DATE(column_name) FROM table_name;

SELECT '1999-05-15 03:45:10'::TIMESTAMP::DATE;

SELECT DATE(SUBSTRING('1999-05-15 03:45:10' FROM 1 FOR 10));

Result:

‘1999-05-15 03:45:10’ ---- ‘1999-05-15’