PostgreSQL current_timestamp function.

Preamble

PostgreSQL current_timestamp function returns the current date and time with the time zone.

Syntax of the current_timestamp function in PostgreSQL

current_timestamp( [ precision ] )

Parameters and function arguments

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

Note:

• The current_timestamp function returns the current date in ‘YYYY-MM-DD HH:MM:SS.US+TZ’ format.
• Do not put brackets () after the current_timestamp function if the precision parameter is not specified.

The current_timestamp function can be used in future versions of PostgreSQL

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

SELECT current_timestamp;

--Result: 2019-04-23 11:12:12.616092+03

SELECT current_timestamp(1);

--Result: 2019-04-23 11:13:02.1+03

SELECT current_timestamp(2);

--Result: 2019-04-23 11:13:17.21+03

SELECT current_timestamp(3);

--Result: 2019-04-23 11:13:29.5+03

PostgreSQL: Timestamps And Dates Course

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.