I have one problem, when i made my table i made like this Ex.

create table table_name(buy_date date);

but it taked by defaul this format
date('yyyy-mm-dd');

i want in this formart
date('dd-mm-yyyy');

how can i do that?