Date Field is not insert properly in MYSQl

ashafak

Dear All;
M using a HTML Form in which user put end date of his or her project i want to store that date in mysql via php , Value is inserting but the value is 00:00:0000 . I am tring by making field type date and datetime but both are not giving correct out put . kindly give me solution and reson of this prob.
Do need ful for the same
Thanks

Weedpacket

We can't without seeing the code that you're using to perform the insertion, and also how the data you're trying to insert is formatted.

ashafak

no m not using formating it is a sample text field and date comes

$date = $_POST['date']

and i wana store this into database field type is date in mysql how can i format it and how i can insert it ?

bradgrafelman

The easiest way to have users input dates in the format that you need is to use three <select> boxes - one each for the month, day, and year.

Then, once the form is submitted, you can get the date in the YYYY-MM-DD format that MySQL expects for DATE columns by doing something like:

$date = "$_POST[year]-$_POST[month]-$_POST[day]";