PostgreSQL current_time function.

Preamble

The current_time function in PostgreSQL returns the current time with the time zone.

Syntax of the current_time function in PostgreSQL

current_time( [ precision ] )

Parameters and function arguments

• It is optional. A number of digits for rounding to fractional seconds.

Note:

• The current_time function will return the current time of day in ‘HH:MM:SS.US+TZ’ format.
• Do not put parentheses () after current_time function if the precision parameter is not specified.

The current_time function can be used in future versions of PostgreSQL

Let’s look at some examples of the current_time function to see how to use the current_time function in PostgreSQL.
For example:

SELECT current_time;

--Result: 11:08:46.339427+03:00

SELECT current_time(1);

--Result: 11:09:09.400000+03:00

SELECT current_time(2);

--Result: 11:09:30.580000+03:00

SELECT current_time(3);

--Result: 11:09:51.858000+03:00

Date functions in PostgreSQL, Time functions in PostgreSQL

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.