The **`YEAR()`** function returns the year from a date sent as a parameter.

Figure 1 shows a visual representation of the `YEAR()` function.

# Syntax
```sql
YEAR(date)
```
# Parameter
The `YEAR()` function takes the date as a parameter. 
> The date must be in the format YYYY-MM-DD, or else this function returns `NULL`.

# Return value
The `YEAR()` function returns the year from a date sent as a parameter.  
>It returns `NULL` if the date is invalid.


# Code
The following example shows how we can isolate the year from the admission dates of students using the `YEAR()` function.




Students

SELECT *, YEAR(studentAdmissionDate) as YEAR
from Students;

<h2>Syntax</h2>
```sql
YEAR(date)
```
<h2>Parameter</h2>
The `YEAR()` function takes the date as a parameter. 
> The date must be in the format YYYY-MM-DD, or else this function returns `NULL`.
<h2>Return value</h2>
The `YEAR()` function returns the year from a date sent as a parameter.  
>It returns `NULL` if the date is invalid.
<h2>Code</h2>
The following example shows how we can isolate the year from the admission dates of students using the `YEAR()` function.




What is YEAR() in SQL?

The YEAR() function in SQL extracts the year from a given date in the YYYY-MM-DD format.

*Student ID*	*Student Name*	*Student Admission Date*
1	David	2000-07-14
2	Luiss	2002-08-15
3	Harvey	2005-04-19
4	Lucy	2010-01-27
5	Andrew	2011-10-03