How to convert uk date to mysql date format

Hello,

anyone knows how to convert uk date to mysql date format? I have 3 textboxes having the values of dates.

the format are the following:

textbox1-29/08/2007
textbox2-14/08/2007
textbox3-20/08/2007

upon entering it into the database the following dates should be converted already to the mysql date format like 2007-08-29


tnx...

Are you looking for something like str_to_date (http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_str-to-date)

the date is not yet entered in the database.. It must be converted first to mysql date format before saving it..

insert into table_name(field) values (STR_TO_DATE('08/25/2007', '%m/%d/%Y'))

can u give me an example?

i try but it displays 1970-01-01

$start=$_POST['startdate'];
echo date('Y-m-d',$start);

The example is above. Nowhere in the example shown is the date function