PostgreSQL CURRENT_TIMESTAMP() Function

The PostgreSQL CURRENT_TIMESTAMP() function returns the current date and time with the time zone. This function returns the current date as a 'YYYY-MM-DD HH:MM:SS.US+TZ' format.

Syntax

CURRENT_TIMESTAMP(precision)

Note: Do not put parentheses () after the CURRENT_TIMESTAMP function if the precision parameter is not specified.

Parameters

Return Value

Returns the current date as a 'YYYY-MM-DD HH:MM:SS.US+TZ' format.

Example 1:

The example below shows the usage of CURRENT_TIMESTAMP() function.

SELECT CURRENT_TIMESTAMP;
Result: '2021-12-27 08:01:29.125744+00'

SELECT CURRENT_TIMESTAMP(1);
Result: '2021-12-27 08:01:29.1+00'

SELECT CURRENT_TIMESTAMP(2);
Result: '2021-12-27 08:01:29.13+00'

SELECT CURRENT_TIMESTAMP(3);
Result: '2021-12-27 08:01:29.126+00'

SELECT CURRENT_TIMESTAMP(4);
Result: '2021-12-27 08:01:29.1257+00'

Example 2:

Consider a database table called EmployeeLogin with the following records:

To insert a new record in this table, the following statement can be used.

INSERT INTO EmployeeLogin 
VALUES (6, 'Suresh', CURRENT_TIMESTAMP(0));

-- see the result
SELECT * FROM EmployeeLogin;

This will produce a result similar to: