PostgreSQL localtimestamp function.

Preamble

The localtimestamp PostgreSQL function returns the current date and time.

Syntax of the PostgreSQL localtimestamp function

localtimestamp( [ precision ] )

Parameters and function arguments

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

Note:

• The localtimestamp function returns the current date in ‘YYYY-MM-DD HH:MM:SS.US’ format.
• Do not put brackets () after the localtimestamp function unless a precision is specified.

The localtimestamp function can be used in future versions of PostgreSQL

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

SELECT localtimestamp;

--Result: 2019-04-23 11:53:48.923662

SELECT localtimestamp(1);

--Result: 2019-04-23 11:54:09.8

SELECT localtimestamp(2);

--Result: 2019-04-23 11:54:26.78

SELECT localtimestamp(3);

--Result: 2019-04-23 11:54:51.313

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.​