php 获取 sqlserver 内的datetime 格式的字符串，获取不到

2020-12-10 10:21:56 144 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Leaflet 加载天地图完整配置指南：从插件修改到无限缩放（附源码）本文详细介绍了Leaflet与天地图深度集成的完整配置指南，包括插件修改、无限缩放实现及源码示例。通过解析天地图服务的WMTS协议、双投影支持和密钥机制，帮助开发者突破缩放级别限制，优化地图应用性能，适用于Web地图开发和高精度GIS系统。阅读详情



<?php

header("Content-type:text/html;charset=utf-8");

date_default_timezone_set('UTC');

    $serverName = "172.16.200.12,1433";

    $connectionInfo =  array("UID"=>"uid","PWD"=>"pwd","Database"=>"china");

    $conn = sqlsrv_connect( $serverName, $connectionInfo);

    $yesday = date("Y-m-d",strtotime("-1 day"));

    $sql  =  "select * from tb_History2

where time BETWEEN DATEADD(mi, -6, GETDATE()-1) and DATEADD(mi, 6, GETDATE()-1)";

	$stmt  =  sqlsrv_query (  $conn ,  $sql  );

	if(  $stmt  ===  false ) {

	    die(  print_r (  sqlsrv_errors (),  true ) );

	}

    $arr = array();

    $n=0;

	while(  $row  =  sqlsrv_fetch_array (  $stmt ,  SQLSRV_FETCH_ASSOC ) ) {

	      

          $arr[$n] = array(

                           'id'=>$row [ 'id' ],

                           'value'=>$row [ 'value' ],

                           'time'=>$row [ 'time' ],      //这里有问题

                           'name'=>iconv('GB2312','UTF-8',$row [ 'name' ]),

                           's_id'=>$row [ 's_id' ],

                           'P_id'=>$row [ 'P_id' ]

          );

          $n++;

	}



    echo json_encode($arr); 

   	sqlsrv_free_stmt (  $stmt );

    sqlsrv_close( $conn);

?>

当我输出来的时候，time这个字段是空的，为什么会这样？