日期显示问题

sql server ?SELECT convert(char, data ,120) from table

解决方案 »

  1.   

    SELECT convert(char,datefield,120) from table
      

  2.   

    或者你用替换也可以
    function mssqldate($date){
        $ms=array(" 一月 "," 二月 "," 三月 "," 四月 "," 五月 "," 六月 "," 七月 "," 八月 "," 九月 "," 十月 "," 十一月 "," 十二月 ");
        $ms2=array("-1-","-2-","-3-","-4-","-5-","-6-","-7-","-8-","-9-","-10-","-11-","-12-");
        $d=str_replace($ms,$ms2,$date);
        return $d;
    }
      

  3.   

    实在找不到别的原因,只能用syre(神仙)的方法了