业务中需要对某个varchar类型的字段数据做转换,但是部分字段为"",用field::numeric 会报异常,可用以下方式:
select field,cast(coalesce(nullif(field,''),'0')as float) as result from table;
select field,coalesce(cast(nullif(field,'') as float),'0') as result from table
业务中需要对某个varchar类型的字段数据做转换,但是部分字段为"",用field::numeric 会报异常,可用以下方式:
select field,cast(coalesce(nullif(field,''),'0')as float) as result from table;
select field,coalesce(cast(nullif(field,'') as float),'0') as result from table