snowflake-cloud-data-platform - 雪花中小选择查询的数值错误

Question

select to_varchar(nvl(cdi_source,'')) as  cd 
from customer_address 
WHERE best_address_ind = 1;

出现错误

Numeric value 'posp' is not recognized.

cdi_source字段有这样的数据

12    KSRELP
 2    NMCAPT
 3    2018-11-12 00:00:00
 4    2019-03-15 0

标签： snowflake-cloud-data-platform

Answer 1

我同意前面的回答。

尝试使用 TRY_TO_NUMBER 运行您的查询，如下所示：

select to_varchar(nvl(cdi_source,'')) as cd 
from customer_address 
WHERE try_to_number(best_address_ind) = 1;