SQL Function: YEAR()

Definition:

Return the year of provided date in number.

---

Command Syntax:

YEAR(date)

---

Command Example:

Table STUDENT

SID	SNAME	CLASS	CNO	DOB
010122	Chris Wong	1A	5	2011-02-01
010142	Nico Lin	1C	7	2011-08-21
010133	Amy Chan	2D	12	2010-03-06

Input:

SELECT YEAR(DOB) AS Result FROM STUDENT;

Output:

Result
2011
2011
2010

---

‘Just a year’By secondary 6 student