• Home
• PostgreSQL Home
• ▼DATE and TIME function
• AGE function
• CLOCK_TIMESTAMP function
• CURRENT_DATE function
• CURRENT_TIME function
• CURRENT_TIMESTAMP function
• DATE_PART function
• DATE_TRUNC function
• EXTRACT function
• ISFINITE function
• JUSTIFY_DAYS function
• JUSTIFY_HOURS function
• JUSTIFY_INTERVAL function
• LOCALTIMESTAMP function
• NOW function
• STATEMENT_TIMESTAMP function
• TIMEOFDAY function
• TRANSACTION_TIMESTAMP function

PostgreSQL DATE_PART() function

Last update on November 13 2023 09:57:50 (UTC/GMT +8 hours)

DATE_PART() function

The date_part() function is used to return the part of a date and time.

Syntax:

date_part(text, timestamp) date_part(text, interval)

Return Type: double precision.

PostgreSQL Version: 9.3

Pictorial Presentation of PostgreSQL DATE_PART() function

Example 1: PostgreSQL DATE_PART() function

The example below finds the hour part from the timestamp (date and time specified in the argument) .

code:

SELECT date_part('hour', timestamp '2002-09-17 19:27:45');

Sample Output:

date_part ----------- (1 row)

Example 2: PostgreSQL DATE_PART() function

The example below extracts the months part the given age.

Code:

SELECT date_part('month', interval '3 years 7 months');

Sample Output:

date_part ----------- (1 row)

Previous: CURRENT_TIMESTAMP function
Next: DATE_TRUNC function

Follow us on Facebook and Twitter for latest update.