time from timestamp postgresql code example

Example: postgres get timestamp

SELECT CURRENT_TIMESTAMP;