Year | DATE_YEAR

Syntax

DATE_YEAR( [value = CURRENT_DATE()] )

Parameters

value
A DATE value. If the value is not a DATE, it will be converted to one with the DATE operation.

Return Value

Returns the UTC year value of the VALUE as an INTEGER

Description

Get the year value of a DATE

Examples

DATE_YEAR("2017-08-30T17:36:23.000Z") # returns 2017