how to get timestamp now in psql code example

Example: postgres get timestamp

SELECT CURRENT_TIMESTAMP;