Current_Timestamp

Returns the current date and time.

CURRENT_TIMESTAMP

Use the CURRENT_TIMESTAMP function to retrieve the current date and time in a data type of timestamp.

The following example displays the result of a call to CURRENT_TIMESTAMP:

testdb=# SELECT CURRENT_TIMESTAMP AS date_and_time;
      date_and_time
----------------------
 2001-09-04 19:48:21-08
(1 row)