postgres datetime vs timestamp code example

Example: postgres get timestamp

SELECT CURRENT_TIMESTAMP;