1 of 1

Extract

This section contains reference documentation for the Extract function.

Returns the selected field from the DATETIME expression.

EXTRACT(field FROM expression)

select EXTRACT(MONTH FROM '2017-06-15')

value

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

value

2017

This section contains reference documentation for the Extract function.

Returns the selected field from the DATETIME expression.

EXTRACT(field FROM expression)

select EXTRACT(MONTH FROM '2017-06-15')

value

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

value

2017