EXTRACT (extract_field, extract_source)

Returns the extract_field portion of the extract_source. The extract_sourceargument is a date, time or interval expression.

The permitted values of extract_field are:

YEAR
MONTH
DAY
HOUR
MINUTE
SECOND

These values are returned from the target expression.

Thursday, 18 April 2019 Posted in Time and Date Functions