当后面字段为EN000502时,单位是月份,当字段为EN000501时候单位是年份,当字段为EN000503时单位是天数。
(case when applydeadlineUnit='EN000502' then applydeadline/12 when applydeadlineUnit='EN000501' then applydeadline else applydeadline/365 end ) as d
没有看明白。你要什么结果。。case when ???