# Performing Date Calculations : Year « Date Time « SQL / MySQL

Home
SQL / MySQL
 1 Aggregate Functions 2 Backup Load 3 Command MySQL 4 Cursor 5 Data Type 6 Database 7 Date Time 8 Engine 9 Event 10 Flow Control 11 FullText Search 12 Function 13 Geometric 14 I18N 15 Insert Delete Update 16 Join 17 Key 18 Math 19 Procedure Function 20 Regular Expression 21 Select Clause 22 String 23 Table Index 24 Transaction 25 Trigger 26 User Permission 27 View 28 Where Clause 29 XML
 SQL / MySQL » Date Time » Year
Performing Date Calculations
 ```      mysql> mysql> mysql> CREATE TABLE sales_rep(     ->   employee_number INT,     ->   surname VARCHAR(40),     ->   first_name VARCHAR(30),     ->   commission TINYINT,     ->   date_joined date,     ->   birthday date     -> ); Query OK, 0 rows affected (0.00 sec) mysql> mysql> INSERT INTO sales_rep values(1,'James','Writer',10, '1989-01-01', '1969-02-02'); Query OK, 1 row affected (0.00 sec) mysql> mysql> SELECT YEAR(NOW()) - YEAR(birthday) FROM sales_rep; +------------------------------+ | YEAR(NOW()) - YEAR(birthday) | +------------------------------+ |                           42 | +------------------------------+ 1 row in set (0.00 sec) mysql> mysql> drop table sales_rep; Query OK, 0 rows affected (0.00 sec) mysql>                           ```
Related examples in the same category
 1 Date function: YEAR 2 Retrieve year from a date 3 Use YEAR in where clause 4 Determining the Number of Records by Day, Month, and Year 5 To find the earliest birthday within the calendar year, sort by the month and day of the birth values 6 Extract the year part of the reference date and use normal arithmetic to add 10, 20, and 40 to it 7 The following query shows two ways to determine the date for Christmas two years hence. 8 Performing Leap Year Calculations 9 Another way to compute a year's length is to compute the date of the last day of the year and pass it to DAYOF 10 Using Leap Year Tests for Month-Length Calculations 11 February 29 of leap years and March 1 of non-leap years appear to be the same day: 12 Extract the year from a date value by using the YEAR() function: YEAR() 13 Calculate a numerical value for the day, as it falls in the year: DAYOFYEAR() 14 Add a YEAR column type 15 %m returns the month (01-12), %d returns the day (01-31), and %Y returns the year in four digits. 16 Use the YEAR() function 17 For each player, find the player number, the year in which he or she joined the club, and the player's age gro 18 Find the player number, the year in which he or she joined the club, the town where he or she lives, and a cla 19 Get the payment number and the year of each penalty paid after 1980. 20 Get the penalties that were paid between Christmas 1982 (December 25) and New Year's Eve. 21 For each player whose number is less than 60, get the number of years between the year in which that player jo 22 Get the numbers of the players who were born in the same year as player 27. 23 Get year value from date type and compare 24 Get day name, month name and day of year 25 Get the year of a date and compare 26 Get the Year value from subquery 27 Compare the year value in where clause 28 Year value in 29 Distinct year value 30 Group by year 31 HAVING MAX(YEAR(PAYMENT_DATE)) = 1984 32 Check year value 33 ON SCHEDULE EVERY 1 YEAR 34 WHERE clause uses only part of the date column in the comparisons: 35 Calculate an age as of the beginning 1975 for someone born on 1965-03-01. 36 How old are the Smith children today? 37 Determining Ages in Months