D d/m/y Convert to another format PHP

Question

I have date stamps from external source as per below format

Tue 6/02/2018

However when trying to convert the date to Y-m-d for SQL format the date get skewed, using the below;

date("Y-m-d H:i:s", strtotime('Tue 6/02/2018');
//ends up being Y-d-m

I have set the timezone earlier using

date_default_timezone_set('Australia/Brisbane');

But if I use Fri 2/02/2018 i get the correct date back ... – BENN1TH Mar 11 '18 at 07:19 — BENN1TH, Mar 11 '18 at 07:19
Because `strtotime()` confuse with day and month. – Syscall Mar 11 '18 at 07:20 — Syscall, Mar 11 '18 at 07:20

Syscall · Accepted Answer · 2018-03-11T07:18:15.110

strtotime() cannot parse the format "Tue 6/02/2018" correctly. You have to use DateTime::createFromFormat() to parse from your format.

$time = 'Tue 6/02/2018';
$date = DateTime::createFromFormat("D j/m/Y", $time) ;
echo $date->format("Y-m-d H:i:s") ; // 2018-02-06 07:12:19

You also could use new DateTimeZone() as:

$time = 'Tue 6/02/2018';
$tz = new DateTimeZone('Australia/Brisbane');
$date = DateTime::createFromFormat("D j/m/Y", $time, $tz) ;
echo $date->format("Y-m-d H:i:s") ; // 2018-02-06 17:17:48

D d/m/y Convert to another format PHP

1 Answers1