MySQL

295 guides

keyboard_arrow_down

Other math topics

Dagster

Pandas

NumPy

Matplotlib

PySpark

MySQL

chevron_leftDate and Time

DATE, DATETIME and TIMESTAMP TIME YEAR

check_circle

Mark as learned

thumb_up

thumb_down

chat_bubble_outline

Comment

auto_stories Bi-column layout

settings

MySQL | YEAR

schedule Aug 11, 2023

Last updated

local_offer

MySQL

Tags

tocTable of Contents

expand_more

Implicit conversion

mode_heat

Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!

MySQL's YEAR type is used to represent a year value. It is represented as follows:


        
        
            
                
                
                    YYYY or 'YYYY'

A few useful points to note:

Each year value is 1-byte
YEAR type is stored using 4 digits. MySQL 8.0 does not support 2-digit YEAR(2) data type.
Supported range is 1901 to 2155. It also allows for the zero year 0000.

Implicit conversion

For columns with YEAR data type, MySQL implicitly converts 1 or 2 digit strings / digits according to the below:

String / Digit	Range	Converted YEAR value
String	`'1'` - `'69'`	`2001` to `2069`
String	`'70'` - `'99'`	`1970` to `1999`
Digit	`1` to `69`	`2001` to `2069`
Digit	`70` to `99`	`1970` to `1999`

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

Official MySQL Documentation

https://dev.mysql.com/doc/refman/8.0/en/year.html

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!