Insert DATE to MySQL DB - Error

Question

I get an error when i try to string replace the date and save it in the mySQL db. The reason is the format of the DATE field. i have added my PHP code, and mySQL error message below.

$nowDate = str_replace('/', '-', $_POST['datenow']); 

echo $nowDate;

Output > 08-15-2012 , I am inserting this record to the database, but the MySQL database requires the format yyyy-mm-dd (2012-08-15) or else i get an error

Unable1 to run query:Incorrect date value: '08-15-2012' for column 'now_date' at row 1

newfurniturey · Accepted Answer · 2012-08-13 18:37:37Z

6

As the error specifies, the format of the date needs to be yyyy-mm-dd.

You can format it prior to inserting it with date() and strtotime():

$nowDate = date('Y-m-d', strtotime($_POST['datenow']));

answered Aug 13, 2012 at 18:37

newfurniturey

38.6k10 gold badges99 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mike Brant · Accepted Answer · 2012-08-13 18:40:55Z

3

Try this

$nowDate = date('Y-m-d',strtotime($_POST['datenow']));

Or better yet, if you are just trying to add the current date, let MySQL do it for you like this. This eliminate the need to sanitize the input data.

INSERT INTO table SET date_field = NOW();

answered Aug 13, 2012 at 18:40

Mike Brant

71.4k10 gold badges102 silver badges104 bronze badges

Comments

Marc B · Accepted Answer · 2012-08-13 18:38:32Z

0

So... what's the problem? You've already said you know MySQL requires a certain format, but want to use a format that's not supported. If you insist on using your 'bad' format, then investigate using STR_TO_DATE() within your insert query, or convert your PHP string into a valid MySQL date format.

answered Aug 13, 2012 at 18:38

Marc B

362k44 gold badges433 silver badges508 bronze badges

1 Comment

Mike Over a year ago

I was just about to post this. Not sure why someone voted you down.

Collectives™ on Stack Overflow

Insert DATE to MySQL DB - Error

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related