postgres date get time seconds code example

Example: postgres get timestamp

SELECT CURRENT_TIMESTAMP;