Convert date and time format in passed date value from db

Question

I have a date value from the database and its format is: YYYY-mm-dd hh:mm:ss I want to convert it to this format: YYYY/mm/dd hh:mm

Here is my code:

<?php 
    $datetime = $value['last_online']; //from db
    $date = date('d-m-Y', $datetime);
    $time = date('Gi.s', $datetime);
    echo $date.' '.$time;
?>

But it's not working and is giving me an error of:

A non well formed numeric value encountered

I want to get rid of the minus signs and the seconds so my new date and time format would be YYYY/mm/dd hh:mm. How do I do it?

Any ideas?

$date = date('d-m-Y H:i', $datetime); – aldrin27 Mar 16 '16 at 08:30 — aldrin27, Mar 16 '16 at 08:30
Thanks. But, still the same error. – Ethelene Laverne Mar 16 '16 at 08:33 — Ethelene Laverne, Mar 16 '16 at 08:33

score 1 · Accepted Answer · answered Mar 16 '16 at 08:32

1

Use like below

$datetime = $value['last_online']; //from db
$date = date('Y/m/d h:i', strtotime($datetime));

answered Mar 16 '16 at 08:32

Apoorv

231
1
8

Thanks. But, it doesn't do anything. It returns the same date & time. – Ethelene Laverne Mar 16 '16 at 08:37
What you really want to do? In your question you said you want to change the format S0 it gives the date in changed format – Apoorv Mar 16 '16 at 08:38
Sorry, I echoed the wrong variable. It's okay now. Thanks a lot! – Ethelene Laverne Mar 16 '16 at 08:44
1

Thanks for marking it correct! – Apoorv Mar 16 '16 at 08:45

Convert date and time format in passed date value from db

1 Answers1