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

value
06

value
2017

yearOfWeek

Next - Configuration Reference

Plugin Reference

Last modified 4mo ago