在MSSQL上获取日期时间

Question

I have a Microsoft database and I make a query that returns a series of values. Everything is fine except when I want to get the date, something does not work and I do not know what it is.

Here is the result of the query:

Array ( [0] => DateTime Object ( [date] => 2017-04-10 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Berlin ) [1] => DateTime Object ( [date] => 2017-04-10 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Berlin ) ) Array ( [0] => DateTime Object ( [date] => 2017-04-07 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Berlin ) [1] => DateTime Object ( [date] => 2017-04-07 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Berlin ) ) Array ( [0] => DateTime Object ( [date] => 2017-04-04 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Berlin ) [1] => DateTime Object ( [date] => 2017-04-04 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Berlin ) ) Array ( [0] => DateTime Object ( [date] => 2017-04-10 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Berlin ) [1] => DateTime Object ( [date] => 2017-04-10 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Berlin ) ) Array ( [0] => DateTime Object ( [date] => 2017-04-10 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Berlin ) [1] => DateTime Object ( [date] => 2017-04-10 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Berlin ) ) Array ( [0] => DateTime Object ( [date] => 2017-04-07 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Berlin ) [1] => DateTime Object ( [date] => 2017-04-07 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Berlin ) ) Array ( [0] => DateTime Object ( [date] => 2017-04-10 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Berlin ) [1] => DateTime Object ( [date] => 2017-04-10 00:00:00.000000 [timezone_type] => 3 [timezone] => Europe/Berlin ) )

How can i get the value of "date"? I try with this but i don't get any result:

 echo '</table>';
                 echo '</div>';
                 echo '<div class="tbl-content">';
                 echo '<table cellpadding="0" cellspacing="0" border="0">';
                 echo '<tbody>';
                 while ($row = sqlsrv_fetch_array($result)){
                            echo "<tr>";
                            echo "<td>$row[0]</td>";
                            echo "<td>$row[1]</td>";
                            echo "<td>$row[2]</td>";
                            echo "<td>$row[4]</td>";
                            if($row[7]== '1') {
                                echo "<td>Si</td>";
                            } else if($row[7]== '0') {
                                echo "<td>'No'</td>";
                            }
                            echo "<td>$row[5]</td>"; //NO RESULT THERE


                            echo "</tr>";
                        }
                        echo '</tbody>';
                        echo '</table>';
                        echo '</div>';

Answer 1

PHP objects have their own properties and methods. You cannot simply echo (print) the object and expect to get a string. Checking documentation or var_dumping an object can give you the method or property you should use to access the string value. In this case it is a DateTime object so you should be able to use DateTime::format('Y-m-d') to access the date and format it.

http://php.net/manual/en/book.datetime.php

In your specific case you should be able to use $row[0]->format('Y/m/d H:i:s') for each of your date objects to get them as string. Obviously changing the index where applicable.