GETDATE

Return the current timestamp on any database.

GETDATE()

For example:

premdb=# select getdate();
          getdate           
----------------------------
 2020-09-22 14:59:37.720194
(1 row)

GETDATE is similar to CURRENT_TIMESTAMP but returns a TIMESTAMP value rather than a TIMESTAMPTZ value. See CURRENT_TIMESTAMP. For example:

premdb=# select getdate(), current_timestamp as current_timestamp;
          getdate           |       current_timestamp       
----------------------------+-------------------------------
 2020-09-22 15:06:07.179172 | 2020-09-22 15:06:07.179172-07
(1 row)