w3resource

PostgreSQL CURRENT_TIME() function

CURRENT_TIME() function

This function is used to return the current time with a zone.

Syntax:

current_time()

Return Type: time with time zone.

PostgreSQL Version: 9.3

Pictorial Presentation of PostgreSQL CURRENT_TIME() function

Pictorial presentation of postgresql CURRENT_TIME function

Example: PostgreSQL CURRENT_TIME() function

Code:

SELECT current_time;

Sample Output:

     timetz
-----------------
 16:33:22.719-08
(1 row)

N.B. - The outputs may change with current time.

Previous: CURRENT_DATE function
Next: CURRENT_TIMESTAMP function