假如时间字段是fkdate,则
select CONVERT(varchar(19) , fkdate, 120) from alasea_dingdan;
结果类似2009-11-02 17:06:00
如果只想获得日期,则
select CONVERT(varchar(10) , fkdate, 120) from alasea_dingdan;
结果类似2009-11-02
select CONVERT(varchar(19) , fkdate, 120) from alasea_dingdan;
结果类似2009-11-02 17:06:00
如果只想获得日期,则
select CONVERT(varchar(10) , fkdate, 120) from alasea_dingdan;
结果类似2009-11-02