问个比较怪的问题!

把字段类型改为 char 就ok了

解决方案 »

  1.   

    select convert(varchar(10),日期字段,120) from tb
      

  2.   

    我是从有很多字段里的一个表里取数据,而且每个字段里的数据都要,所以我用select *!
    不能用楼上哪个办法,还有好办法吧@
      

  3.   

    function myDate($v) {
      $p = array("/一月/","/二月/","/三月/","/四月/","/五月/","/六月/","/七月/","/八月/","/九月/","/十月/","/十一月/","/十二月/","/ +/");
      $r = array("-1-","-2-","-3-","-4-","-5-","-6-","-7-","-8-","-9-","-10-","-11-","-12-","");
      return date("Y-m-d",strtotime(preg_replace($p,$r,$v)));
    }$d = "2003 十一月 10";
    echo myDate($d);最好少用*，虽然简单，但会时查询速度变慢