how to retrieve a sql datetime object with a php $row?

Question

For instance:

$sql = "SELECT * FROM db";
$query = sqlsrv_query($conn, $sql);

while($row = sqlsrv_fetch_array($query)){
    echo "$row[date_column]";
}

will crash

Most of the answers I've found are assuming you want to order your query by a datetime, but I just want to turn the datetime object into a string after I have all the rows.

I don't really understand how to use the php date() function, I've tried:

echo date("m/d/Y",$row[date_column]); //prints nothing

Solution

$string=$row["date_column"]->format('Y-m-d H:i:s')

Comments

[Ozzah]

Question is asking about MSSQL, not MySQL, but I don't see why this method would not work for both.

[Gregg]

Whoops, your right! But yes, it should if MSSQL stores datetime the same.

[not_shitashi]

Hi, thanks for you answer, however, what I am getting from echo date("m/d/Y", strtotime($row["date_column"]); is the date: 12/31/1969 for every entry. Also, that is not the correct date for any of the entries.

[Gregg]

You will get that date when PHP date() is given a bad input value. So I can help you more, can I have a sample of what "echo $row["date_column"];" produces?

[not_shitashi]

it returns a datetime object (for the Data Type in sql) and the format is yyyy-mm-dd hh:nn:ss.xxx where n = minutes and x = milliseconds I think.

[Gregg]

That's strange. It works when I try it on my server, with the format you provided. The code I am trying is: "$time = "2001-01-13 10:45:55.123"; echo date("m/d/Y", strtotime($time));" Which produces: "01/13/2001". What do you get when you just try "echo strtotime($row["date_column"]);"?