PostgreSQL CURRENT TIME Function

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

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

 

Example : PostgreSQL CURRENT_TIME() function

SELECT current_time;

Output :

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

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