Hi ! i am using mysql with php. I have used a form where user enter date in format mm-dd-yy. I want to insert that date in database. But according to my knowledge this format is not accepted by mysql instead it accepts yy-mm-dd . So please guide me what should i do.
Use a text or varchar field type, rather than a date type.
You'll probably want to parse the date into year, month, day using some string functions... and reconstruct it to post the db...