Im just wondering if its possible to set values automatically. For example theres data in my database that have dates of birth and some of them have all info filled in like 1953/12/25 and then some have just 1953. Is it possible that i can use some sort of code to automatically put the values with just the year or values that have 1953/1/9 to be 1953/00/00 and 1953/01/09? I'm pretty new to MySQL so im not sure if this is possible.
Thanks for the help.

you need to update the records.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.