摘要:
a.JLDate为非标准日期格式:例:2011-8-28 0:00:000011-8-28 0:00:000111-8-4 0:00:00select CONVERT(varchar(50),CONVERT(datetime, a.JLDate, 120),120) as JLDate,b.ch,b.bh,cast((cast(b.mz as decimal(18,6))/1000) as decimal(18,6)) as mz,a.ExeCode as zzdmfrom oil_JLHead a left join oil_JLItem b on a.JLHead_ID = b.JLHea 阅读全文