SELECT REPLACE ( SUBSTRING ( SUBSTRING ( @C,FROM_CHAR, TO_CHAR - FROM_CHAR ) ,14,30) , MM,DIG ) split_char ,
CAST( REPLACE ( SUBSTRING ( SUBSTRING ( @C,FROM_CHAR, TO_CHAR - FROM_CHAR ) ,14,30) , MM,DIG ) as datetime ) datetime_char
FROM FROM_TO , MONTH_TO
WHERE SUBSTRING ( SUBSTRING ( @C,FROM_CHAR, TO_CHAR - FROM_CHAR ) ,14,30) like '%'+ MM + '%'
CAST( REPLACE ( SUBSTRING ( SUBSTRING ( @C,FROM_CHAR, TO_CHAR - FROM_CHAR ) ,14,30) , MM,DIG ) as datetime ) datetime_char
FROM FROM_TO , MONTH_TO
WHERE SUBSTRING ( SUBSTRING ( @C,FROM_CHAR, TO_CHAR - FROM_CHAR ) ,14,30) like '%'+ MM + '%'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货