My database table is returning years as
1999, 2000, 2001, 2002 from the year_description field. I want to assign a unique char datatype (year_code) to this.
For Example -
I can not modifying/add anything in the database. How can I do this in SQL or java