CURRENT_TIMESTAMP
This function does not accept parameters.
The current date and the current time. The return data type is 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)