I have a field called vaccinationdate in a table with datatype DATE, but the values of that field have different formats. now I cant change the datatype of this column and the client says this is how the values will be since in case if the patient doesn't know the exact date of vaccination they would just mention the month and year. please help me to insert these values in the table.
ex: Values are like:
Thanks in advance for your help!