PostgreSQL Current Time: Get Timestamp Now

In PostgreSQL database, you can retrieve the current time using the following SQL query.

SELECT CURRENT_TIMESTAMP;

This will return the timestamp of the current date and time. You can also use the NOW() function to retrieve the current date and time.

SELECT NOW();

This will also return the timestamp of the current date and time.