YY HH:MM:SS to Monday, 1st Jan 2015

Asked Oct 26 '15 at 15:00

Active Oct 26 '15 at 15:31

Viewed 29 times

I have a date as follows in the DB: 14/6/2015 00:00:00

I would like to change this to Sunday, 14th June 2015

I tried the following but no luck. Any advice?

$dateStart = get_post_meta( get_the_ID(), 'startdate' , true); // 14/6/2015 00:00:00
$dateStart = date('l, d F Y', strtotime($dateStart));
$dateStart = get_post_meta( get_the_ID(), 'startdate' , true);
$dateStart = DateTime::createFromFormat('d/m/Y h:i:s', $dateStart);
$dateStart = $dateStart->format('m/d/Y');
$dateStart = date('l, d F Y', strtotime($dateStart));

I have tried other threads such as Convert one date format into another in PHP and followed what they have said but it just doesn't work for me, unless I am missing something very obvious

edited May 23 '17 at 12:14

Community

asked Oct 26 '15 at 15:00

pee2pee

3,619
7
52
133

You need to use `createFromFormat` since that is a non-standard format and `stringtotime` chokes on it. – AbraCadaver Oct 26 '15 at 15:05
Fixed it but it seems a lot of work for something so simple - updated – pee2pee Oct 26 '15 at 15:08
1

Get rid of your last 2 lines and just use `$dateStart = $dateStart->format('l, d F Y');` – AbraCadaver Oct 26 '15 at 15:16
Thanks - still seems like a lot of work :-( might look to updating SQL – pee2pee Oct 26 '15 at 15:24
The problem is that `d/m/Y` is not a standard date format. `m/d/Y` is for the US and `d-m-Y` for Europe/others. – AbraCadaver Oct 26 '15 at 15:41
Based in the UK and we only ever use dd/mm/yyyy - not to worry - thanks for the help – pee2pee Oct 27 '15 at 09:49

PHP Convert DD/MM/YY HH:MM:SS to Monday, 1st Jan 2015

0 Answers0