PHP script can not format the date [duplicate]

Question

I have a datepicker that shows the date in the following format: date('d/m/Y') the date is represented as: 29/06/2017.

The date column in my database accepts the format: Y-m-d. Witch is represented as: 2017-06-29.

I am trying to convert the date with the following script:

$single_cal4 = date("Y-m-d",strtotime($single_cal4));

When I execute the PHP script that sends the date to the database the date will not insert. I get the date 1970-01-01 in my database.

Does someone know why this is happening and what I am doing wrong?

Append an $single_cal4 = replace("/" ,"-", $single_cal4); to your line — Richard
– Richard, Commented Jun 29, 2017 at 14:57
Please read The 3rd NOTE in the manual for strtotime() The manual is always a good place to START your debugging process — RiggsFolly
– RiggsFolly, Commented Jun 29, 2017 at 14:57

Sanan Guliyev · Accepted Answer · 2017-06-29 14:55:24Z

3

Maybe reason is $single_cal4. You make sure that $single_cal4 is valid date string. In other way you can try this:

$myDateTime = DateTime::createFromFormat('d/m/Y', $single_cal4);
$newDateString = $myDateTime->format('Y-m-d');

answered Jun 29, 2017 at 14:55

Sanan Guliyev

7616 silver badges12 bronze badges

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

3 Comments

I get an error with your script

Can you share error?

My mistake. It is working. Thanks