Dates with missing months or days (e.g. 1670-00-00)

PHP
1

I’m not sure if this is a PHP or MySQL question, but here goes.

I have a database table filled with people’s birthdays (e.g. 1970-07-08). But what do I do with people whose birthdays aren’t precisely known?

For example, one historical figure was born in 1570. So I put this in my database: 1570-00-00. But it displays November 30, 1569.

This is the code I’m using, where $Born is a date stored in the database…


 $Born = $row['Born'];

 $Birth = DateTime::createFromFormat('Y-m-d', $Born);

And here’s a similar question: What would be a good solution for a person born ABOUT or CIRCA a certain date or year? Is there some way of noting that in PHP or MySQL, or should I just use a PHP switch to list exceptions and input their birthdays manually?

Thanks.

2

What is the field type for “Born”?

3

date