Save different date format

Hello, I have been looking for a way to save different format of a date. In my form, I would like to save the “release_date” field, but sometimes I only know the year or year / month of the date.

The only way I have found is to create a field for year, month and day. Is this a good solution for my problem?

Thanks guys !

@kentosama can yo;u provide some you are inserting
according to my knowledge if you select datetime formate in database for this kind of data and somehow save data using ajax or some other approach then you can store date , time, year and month separately the remaining date,moth,or year will saved 00:0000 or something like that.
try this it can help you