YEAR

YEAR takes a date and returns a four-digit integer representing the year on which it falls.

Syntax

YEAR(arg1)

  • arg1 is a date object or a function that resolves to a date object

Example

Let's say we received a response with some insurance claim information:

{
"data":{
"claim": {
"issue_number": "2a515",
"date": "NOW()"
}
}
}

If we wanted to find the year for the value of the date field, which is set to the value of NOW, we could use YEAR:

YEAR(data.claim.date)

Which would return an integer with the year at the time of calling.

The structure of the date response returned follows the ISO 8601 standard.