Display Y-m-d format for wrong date format input in php

Question

I have an excel sheet with dates in Y/m/d H:i:s format. But in case if a user accidentally typed 2019/29/10 16:20:10 (ie, Y/d/m H:i:s) format it should convert to Y-m-d H:i:s format as 2019-10-29 16:20:10.

I have used the following strotime but it converted the Y/d/m format to 1970-01-01

$date = date('Y-m-d h:i:s', strtotime($rows[$i][2]));

If by mistake month and date got swapped, can we save and display the same in Y-m-d format??

If they enter 2019/02/04 - how will you know if it's in the wrong format or not? — Nigel Ren, Oct 31 '19 at 09:55
Possible duplicate of [Convert one date format into another in PHP](https://stackoverflow.com/questions/2167916/convert-one-date-format-into-another-in-php) — Dilip Hirapara, Oct 31 '19 at 10:05
If the user mistyped it you need to reject it. You can't guess what kind of typo the user made. — Dharman, Oct 31 '19 at 10:10
I would rather give the user an error message saying that they need to write the date in the correct format. — M. Eriksson, Oct 31 '19 at 10:10
If you use laravel, you should use carbon instead of `strtotime()` — Dharman, Oct 31 '19 at 10:20
As @MagnusEriksson suggested, I should better give an error message. Thank you all for the valuable comments. — Oops, Oct 31 '19 at 10:44

score 0 · Answer 1 · answered Oct 31 '19 at 11:15

If you don't have any date then default date will be 1970-01-01 so please use condition before if

if($rows[$i][2]){
 date('Y-m-d h:i:s', strtotime($rows[$i][2]));
}

Another way is using Carbon in Laravel Blade Template

{{ \Carbon\Carbon::parse($rows[$i][2])->format('Y-m-d h:i:s')}}

Display Y-m-d format for wrong date format input in php

1 Answers1