I'm aware this question is some days old meanwhile, but if I were you, I'd use TEXT and store the date information as JSON:
``INSERT INTO table(date) VALUES (json_object('year',2021,'month',6,'day',NULL));``
I'm aware this question is some days old meanwhile, but if I were you, I'd use TEXT and store the date information as JSON:
``INSERT INTO table(date) VALUES (json_object('year',2021,'month',6,'day',NULL));``