mysql timestamp conversion/formatting Notice: A non well formed numeric value encountered

Question

In my database I have set row "posted" as a timestamp but I get this notice when trying to convert/format it:

Notice: A non well formed numeric value encountered

code:

$posted = date('d/m/Y H:i:s', $row['posted']);
    echo $posted;

what am I doing wrong?

Answer 1

This means that the second parameter for date() is expecting integer, so convert $row['posted'] to timestamp first.

Try

$posted = date('d/m/Y H:i:s', strtotime($row['posted']));