Product Documentation

Appearance

All platforms

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)