CODEWITHSUNDEEP
phpmysql
phpaddict
phpaddict

Reputation:

Inserting mm/dd/yyyy format dates in MySQL

How can I insert an MM/DD/YYYY format date into an MySQL database using PHP?

Upvotes: 5

Views: 33848

Answers (2)

Jan Jungnickel
Jan Jungnickel

Reputation: 2114

This can be done using STR_TO_DATE.

Example: 

INSERT INTO useless_table (id, date_added) VALUES(
            1, STR_TO_DATE('03/08/2009', '%m/%d/%Y'));

EDIT: Please also consider MarkR's solution, because it's the right thing to do[tm].

Upvotes: 25

MarkR
MarkR

Reputation: 63538

MySQL support ISO-8601 date/time values, and no others. If you need to use some other whacky format (for example, because you have American customers who expect wonky dates), you need to do the conversion yourself.

Just live with it, ISO-8601 is the one true date format.

Upvotes: 7

Related Questions