SqlExpression EXTRACT

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Input 4 Output 5 Example

Syntax

EXTRACT( field FROM interval )

Purpose

Retrieves the sub-fields from an interval value (Note: this is only supported for a subset of fields, and retrieval of sub-fields from date or timestamp is not supported)

Input

• field - sub-field to be extracted
• interval - the interval that field is extracted from

Output

• [BIGINT] - value of the sub-field

Example

+ Supported field and interval combinations

Field	Interval	Example Function	Example Result
DAY	day-time	EXTRACT( DAY FROM INTERVAL '2 3:4:5.678' DAY TO SECOND )	2
HOUR	day-time	EXTRACT( HOUR FROM INTERVAL '2 3:4:5.678' DAY TO SECOND )	3
MINUTE	day-time	EXTRACT( MINUTE FROM INTERVAL '2 3:4:5.678' DAY TO SECOND )	4
SECOND	day-time	EXTRACT( SECOND FROM INTERVAL '2 3:4:5.678' DAY TO SECOND )	5
YEAR	year-month	EXTRACT( YEAR FROM INTERVAL '4-2' YEAR TO MONTH )	4
MONTH	year-month	EXTRACT( MONTH FROM INTERVAL '4-2' YEAR TO MONTH )	2

---

Return to Built in Function details