currently my MysQL table store a feild called

DOB

and the date has to be entered as

yyyy/mm/dd

i would like it to be

dd/mm/yyyy

how do i do this please

sorry for asking such a silly question

Andy

Mysql uses the yyyy-mm-dd DATE/DATETIME format as it makes sorting and comparisons work correctly.

If you want mysql to covert the format on input and output, you need to use the - DATE_FORMAT(date,format) - function.

This function is of some use as well -