Creating table with one column having year datatype

Question

How do I create a table with one column having year e.g. 2019, 2018 as the only data type?

https://stackoverflow.com/q/696506/6877477 – Anton Kahwaji Apr 08 '19 at 00:51 — Anton Kahwaji, Apr 08 '19 at 00:51

score 1 · Answer 1 · answered Apr 08 '19 at 04:11

You can store a year either as an integer (or smallint, if your database supports it), decimal(4, 0), or as a char(4).

You would use a numeric representation if you planned to do arithmetic on the years -- say adding 3 years or taking the difference. You would use a string representation if the value were only for show.

score 0 · Answer 2 · answered Apr 08 '19 at 04:29

0

Use INT datatype. There is no need to use Decimal or Varchar

answered Apr 08 '19 at 04:29

Farid Arab

1
1

score 0 · Answer 3 · answered Apr 08 '19 at 08:03

0

I would use type DATE because you may want to use functions or expressions that use data with type DATE, perhaps in a different table.

answered Apr 08 '19 at 08:03

Marichyasana

2,966
1
19
20

Creating table with one column having year datatype

3 Answers3