PostgreSQL Date & Time Function

A list of all important Date and Time related functions:

AGE(timestamp, timestamp) & AGE(timestamp):

Let's take an example to check the AGE(timestamp, timestamp) query.

See this example:

Open query page by pressing Ctrl+E.

Execute this query:

SELECT AGE(timestamp '2016-01-26', timestamp '1947-08-15');

Example for function AGE(timestamp) is:

It is used to produce the current age.

Execute the following query:

SELECT AGE(timestamp '1947-08-15');

Current DATE/TIME()

Following is a list of functions that return values related to the current date and time.

Now, you can check the following commands:

For current time:

SELECT CURRENT_TIME;

For current date:

SELECT CURRENT_DATE;

For current timestamp (date and time both)

SELECT CURRENT_TIMESTAMP;

Current timestamp with more precision:

SELECT CURRENT_TIMESTAMP(2);

Local Timestamp:

SELECT LOCALTIMESTAMP;