Format date from php mysql query datetime datatype

Question

I have a php mysql query for a datetime. The result from the query is:

2017-09-04 11:58:26

I use the below and it appears the time is wrong.

$date_time = new DateTime($row['act_date_long']);
$date_time->format('D n/j/Y g:s a')

The result I get is:

Mon 9/4/2017 11:26 am

I need the result to be

Mon 9/4/2017 11:58 pm

What is causing the time difference and how do I format the datetime to my desired format? Thanks!

11:00 is AM if you don’t give any more information. You need to either store the time in 24 hour format, or store AM/PM too. — ishegg
– ishegg, Commented Sep 5, 2017 at 6:07
$date_time->format('D n/j/Y g:i a'); it should be i(for minute) instead of s(for second) — Bhaskar Jain
– Bhaskar Jain, Commented Sep 5, 2017 at 6:17
Your time 2017-09-04 11:58:26 is in 24hr format. Then how could you make 11:58:26 as PM? If it was 23:58:26 it will be PM — Sreejith BS
– Sreejith BS, Commented Sep 5, 2017 at 6:38

Nigel Ren · Accepted Answer · 2017-09-05 06:30:41Z

2

The format for time is incorrect, your printing g:s which is hours and seconds.

Should be

$date_time->format('D n/j/Y g:i a');

answered Sep 5, 2017 at 6:30

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

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

1 Answer 1