将从数据库检索的日期和时间输入到日期时间输入中

Question

I'm trying to retrieve a Datetime value from my database and place it in an html input with a date type but it doesn't show anything.

$resQuery = mysql_query("SELECT * FROM reserveringen WHERE id = $ID");
while ($resInfo = mysql_fetch_array($resQuery))
        {
          $dateTime = $resInfo[3];
        }

<?php echo "<input name='dateTime' type='datetime-local' value='$dateTime'"?>

Also when I F12 I get this error: The specified value "2525-0505-16161616 0606:0505" does not conform to the required format. The format is "yyyy-MM-ddThh:mm" followed by optional ":ss" or ":ss.SSS".

Answer 1

This fixed it for me guys!

I changed my query to:

SELECT *, DATE_FORMAT(Datum, '%Y-%m-%dT%H:%i') AS Datum_conv FROM reserveringen WHERE id = $ID