case when tmp is null then ‘实际预验’ else split_part(split_part(tmp,’,’,1),’:’,1) end as text,
case when tmp is null then to_char(now(),’yyyy-mm-dd’) else split_part(split_part(tmp,’,’,1),’:’,2) end as start_date,
case when tmp is null then ‘0’ else split_part(split_part(tmp,’,’,1),’:’,3) end as duration
版权声明：本文为m0_58780961原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。