Apache Pinot Docs
latest
Search
K

Extract

This section contains reference documentation for the Extract function.
Returns the selected field from the DATETIME expression.

Signature

EXTRACT(field FROM expression)

Usage Examples

select EXTRACT(MONTH FROM '2017-06-15')
value
06
select EXTRACT(YEAR FROM '2017-06-15 09:34:21')
value
2017