Cant store a date before 12/31/69

[jeff5656]

I have a date of birth field:

If I enter a dte before 12/31/69, for instance 12/1/55:

 

When I do this

 

$_POST['dob']

 

I get 12/1/55, but when I do this:

$dob = date("Y-m-d", strtotime($_POST['dob']));
echo "dob is ".$dob;

I get 12/31/69.  Can mysql not store dates before 1969?

 

 

[Mchl]

MySQL can (use DATE)

Problem is with strtotime which converts string to unix timestamp

http://en.wikipedia.org/wiki/Unix_time

 

You have to use something different to convert your dates, if you want to work on pre 1970 dates

[jeff5656]

When you say something different, what are you referring to?  how do I do convert $_POST[dob] to pre-1970 values?

 

 

[Mchl]

For example use explode to convert your date to an array, then create a string from resultant array that will have YYYY-MM-DD format.