YEAR
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Data Types for MariaDB Xpand
Topics on this page:
EXAMPLES
YEAR Format
CREATE TABLE year_format_example (
description VARCHAR(30),
example YEAR
);
INSERT INTO year_format_example VALUES
('4-digit numeric year', 1966),
('2-digit numeric year', 66),
('4-digit string year', '1966'),
('2-digit string year', '66');
The resulting data would look like this:
SELECT * FROM year_format_example;
+----------------------+---------+
| description | example |
+----------------------+---------+
| 4-digit numeric year | 1966 |
| 2-digit numeric year | 2066 |
| 4-digit string year | 1966 |
| 2-digit string year | 2066 |
+----------------------+---------+
YEAR Range
CREATE TABLE year_range_example (
description VARCHAR(30),
example YEAR
);
INSERT INTO year_range_example VALUES
('minimum', 1901),
('maximum', 2155),
('below minimum', 1900),
('above maximum', 2156);
The resulting data would look like this:
SELECT * FROM year_range_example;
+---------------+---------+
| description | example |
+---------------+---------+
| minimum | 1901 |
| maximum | 2155 |
| below minimum | 0000 |
| above maximum | 0000 |
+---------------+---------+
Zero YEAR
CREATE TABLE year_zero_example (
description VARCHAR(30),
example YEAR
);
INSERT INTO year_zero_example VALUES
('4-digit numeric zero', 0000),
('3-digit numeric zero', 000),
('2-digit numeric zero', 00),
('1-digit numeric zero', 0),
('4-digit string zero', '0000'),
('3-digit string zero', '000'),
('2-digit string zero', '00'),
('1-digit string zero', '0');
The resulting data would look like this:
SELECT * FROM year_zero_example;
+----------------------+---------+
| description | example |
+----------------------+---------+
| 4-digit numeric zero | 0000 |
| 3-digit numeric zero | 0000 |
| 2-digit numeric zero | 0000 |
| 1-digit numeric zero | 0000 |
| 4-digit string zero | 2000 |
| 3-digit string zero | 2000 |
| 2-digit string zero | 2000 |
| 1-digit string zero | 2000 |
+----------------------+---------+
Two-digit YEAR
Xpand does not support a 2-digit YEAR column:
CREATE TABLE year_2_fails (
example YEAR(2)
);
ERROR 1 (HY000): [32770] invalid parameter value: Supports only YEAR or YEAR(4) column.
CHANGE HISTORY
Release Series | History |
|---|---|
6.1 |
|
6.0 |
|
5.3 |
|