Trusted answers to developer questions
Trusted Answers to Developer Questions

Related Tags

sql
mysql
year
communitycreator

What is YEAR() in SQL?

Harris Amjad

Grokking Modern System Design Interview for Engineers & Managers

Ace your System Design Interview and take your career to the next level. Learn to handle the design of applications like Netflix, Quora, Facebook, Uber, and many more in a 45-min interview. Learn the RESHADED framework for architecting web-scale applications by determining requirements, constraints, and assumptions before diving into a step-by-step design process.

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

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

Figure 1: Visual representation of YEAR() function

Syntax

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

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

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

RELATED TAGS

sql
mysql
year
communitycreator

Grokking Modern System Design Interview for Engineers & Managers

Ace your System Design Interview and take your career to the next level. Learn to handle the design of applications like Netflix, Quora, Facebook, Uber, and many more in a 45-min interview. Learn the RESHADED framework for architecting web-scale applications by determining requirements, constraints, and assumptions before diving into a step-by-step design process.

Keep Exploring