Format of Date field

[Anon]

when issuing a "SELECT" statement to the date field how can I return a date in "DD-MM-YYYY" format instead of default "YYYY-MM-DD".

[samscripts]

SELECT date_format(datefield, '%d-%m-%Y') from yourtable

See the mysql manual for all available formats.

[Anon]

Can this format be used in an insert/update statement as well?

[Anon]

You can re-format you date by doing something like this :
insert into table_x (col1, col2,..., coli)
values(val1, date_format(val2,'%Y-%m-%d' ),vali)

To store date in Mysql, use the default Mysql format
good luck