SQL DATE Format

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?

You do date manipulations application side. You can manipulate the query to return the date in a specific format, but that slows the database down, so get all the results in your app, and then manipulate the date on the output stream.

Cheers