Първа пробна новина 1
Also, there is a statement that allows you to set only the YEAR of an event. The Year statement uses an YYYY format and has a range from 1901 to 2155 (for years outside this range you need to use the DATE statement)
Insert a date in MySQL using YEAR
Now let's check how the YEAR statement works in a query. For our example we will use CURDATE() again. As we mentioned above, CURDATE() provides a lot more information than just the year, but when we use the YEAR statement all the date information, besides the year, is ignored.