Title: Can MySql database server store date value in mm-dd-yyyy format?
Tags: mysql;date
Question: Can MySql database server store date value in mm-dd-yyyy format?


Here is the accepted answer: Not as a native ```DATE``` column: Those are always represented as ```YYYY-MM-DD```.

However, you can use ```DATE_FORMAT()``` to output the date in any format you like.

```SELECT DATE_FORMAT(column, "%m-%d-%Y");
```

Comment for this answer: thanks you are like family member to me :) (see you so often)

Here is another answer: You can change the date format client side like this:

```mysql&gt; set date_format = '%m-%d-%Y'; 
```

How the database actually stores the dates should be irrelevant.


Here is another answer: Dates are stored as dates, not strings.
They are not stored in any specific format.

You can retrieve dates in a variety of formats by calling ```DATE_FORMAT```.


Here is another answer: No mysql cannot store date in that format.
It can store dates only in the yyyy-mm-dd format.
u change the format of the data to be inserted or extracted from the mysql db.


{'source': 'StackExchangeDataset', 'subset': 'stackoverflow.com', 'metadata': {'AnswerCount': 4, 'CommentCount': 0, 'ContentLicense': 'CC BY-SA 3.0', 'CreationDate': '2011:00:04/27/11', 'FavoriteCount': 1.0, 'PostTypeId': 1, 'Tags': '<mysql><date>', 'Title': 'Can MySql database server store date value in mm-dd-yyyy format?', 'ViewCount': 3396, 'id': 5811717, 'user_AboutMe': '<p>please delete me</p>\n', 'user_AccountId': 48503.0, 'user_DisplayName': 'eomeroff', 'user_Reputation': 9383.0, 'user_Views': 896.0, 'user_id': 144140.0}}