[RESOLVED] Formating Date

[juminoz]

I'm trying to format the date setting so that it store "dd/mm/yyyy" instead of "yyyy-mm-dd", but I couldn't figure out how to do it. If this is not possible, can I rearrange it when I call the data from the table somehow? Please help.

[nemonoman]

If using MySQL ALWAYS store dates as native DATE type.

To display MySQL DATEs,

SELECT DATE_FORMAT(dateColumn, '%d/%m/%Y')

will display dateColumn as "dd/mm/yyyy".