PostgreSQL now function.

Preamble

The PostgreSQL now function returns the current time and date with the time zone.

Syntax of the now function in PostgreSQL

now ( )

Parameters and function arguments

• There are no parameters or arguments for the function now.

Note:

• The function now will return the current date in ‘YYYY-MM-DD HH:MM:SS.US+TZ’ format.

The function now can be used in future versions of PostgreSQL

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

SELECT now();

--Result: 2019-04-23 11:57:17.177965+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.​