Thanks to all the valuable suggestions given here. I appreciate it very much. Thanks 🙂

Thanks Mike

The table was created as follows:

CREATE TABLE objview(objId VARCHAR(35) REFERENCES obj(objId), viewDate DATETIME, ip VARCHAR(255))

And the query is as simple as:

SELECT DISTINCT YEAR(viewDate) AS year FROM objview WHERE objId=?...