PostgreSQL date_part function.

Preamble

PostgreSQL date_part  function extracts parts from the date.

The syntax of the date_part function in PostgreSQL

date_part( 'unit', date )

Parameters and function arguments

• date – Date, timestamp, time, or interval value from which part of the date is to be extracted.
• Unit – Type of the unit of the interval measurement, such as day, month, minute, hour, etc. E. This may be one of the following:

The date_part function can be used in the following PostgreSQL versions

Consider some examples of the date_part function to understand how to use the date_part function in PostgreSQL with date values.
For example:

SELECT date_part('day', date '2019-04-25');

--Result: 25

SELECT date_part('month', date '2019-04-23');

--Result: 4

SELECT date_part('year', date '2019-04-23');

--Result: 2019

Let’s see how to use the date_part function in PostgreSQL with timestamp values.
For example:

SELECT date_part('day', timestamp '2019-04-23 08:44:21');

--Result: 23

SELECT date_part('month', timestamp '2019-04-23 08:44:21');

--Result: 4

SELECT date_part('minute', timestamp '2019-04-23 08:44:21');

--Result: 44

SELECT date_part('hour', timestamp '2019-04-23 08:44:21');

--Result: 8

Let’s see how to use the date_part function in PostgreSQL with time values.
For example:

SELECT date_part('minute', time '08:44:21');

--Result: 44

SELECT date_part('milliseconds', time '08:44:21.7');

--Result: 21700

Let’s see how to use the date_part function in PostgreSQL with interval values.
For example:

SELECT date_part('day', interval '8 days 4 hours');

--Result: 8

SELECT date_part('hour', interval '8 days 4 hours');

--Result: 4

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.