Problem with Date values!

amycrystal123

Hi,
I am not able to understand how to work with dates in PHP-MySql.
I have 2 select boxes (for month and day) and a text box for year. I validate the values using checkdate(month, day, year) function and I try to insert into a table (MySql database). But how do I convert to MySql format?
I want the values to be stored as mm/dd/yyyy.

How do I convert to Php date format when I retrieve the values. Please answer asap.

Happy Thanksgiving!
Amy.

LordShryku

MySQL's format is yyyy-mm-dd, so you should store them like that. To convert to your format, when you pull them, use this

$formatted = date("m/d/Y", strtotime($dateFromDb));

amycrystal123

Hi,
Thanks for your reply. Could you suggest me how to store a date value to the MySql database. I know it is yyyy-mm-dd format.
But, suppose I have month, day and year strings. How do I convert to a date value to be inserted into the database.

Whatever date values I insert into the DB, I get the standard date value like 1/1/0001. Why is this?

Please help!
Amy

LordShryku

Okay, so you have three variables like this?

$month = "12";
$day = "18";
$year = "2003";

// you can put them together to make the date to insert
$date = $year."-".$month."-".$day;

amycrystal123

Hi,
Thanks for your imm. reply. I do store date values in the format like (yyyy-mm-dd) like you suggested previously. The values get stored in the database too. But, the values I see/retrieve from the DB are always "1/1/0001" whatever value I give!

Where can be the problem?
Pls help.
Amy.

LordShryku

Well, are they stored right in the database? That's the irst place to look. Make sure you have the correct dates in there. Next, look at the code you're using to format the date. Post it up here if you need a second opinion.

amycrystal123

Thanks for your reply. I'll look into the database and get back to you.

Gud Nite!
Amy.