There's no shortage of ways to do the actual conversion, but I think the most important point to understand the data type to use. If you store your dates in a column of DATE or DATETIME, then format is eliminated completely. The data will be stored as that data type. Like Luis and Sean said, the formatting of the data is done when you read it. You can format it however you want to.