get timestamp postgresql from date code example

Example 1: postgres get timestamp

SELECT CURRENT_TIMESTAMP;

Example 2: postgres extract date from timestamp

SELECT DATE(column_name) FROM table_name;