ContraceptionDrugReceive.InputDate = CONVERT(varchar(12) , ContraceptionDrugReceive.InputDate, 111 )
-----------------------------------------------------
在上面语句中使用了111,那个是JAPAN的时间格式,yy/mm/dd 。ContraceptionDrugReceive.InputDate一定不是这个格式。查询出来看看。select
ContraceptionDrugReceive.InputDate,
CONVERT(varchar(12) , ContraceptionDrugReceive.InputDate, 111 )
from ContraceptionDrugReceive,PersonInfo
where ContraceptionDrugReceive.Person_ID = PersonInfo.Person_ID and
-----------------------------------------------------
在上面语句中使用了111,那个是JAPAN的时间格式,yy/mm/dd 。ContraceptionDrugReceive.InputDate一定不是这个格式。查询出来看看。select
ContraceptionDrugReceive.InputDate,
CONVERT(varchar(12) , ContraceptionDrugReceive.InputDate, 111 )
from ContraceptionDrugReceive,PersonInfo
where ContraceptionDrugReceive.Person_ID = PersonInfo.Person_ID and
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货