CODEWITHSUNDEEP
snowflake-cloud-data-platform
Yaswanth Satyanand
Yaswanth Satyanand

Reputation: 1

Numeric value '2021-06-09 06:56:26.702' is not recognized

I have data share view in snowflake which is having around 470 records but while selecting it i am getting "Numeric value '2021-06-09 06:56:26.702' is not recognized" for Numeric(38,0) datatype column. I tried of using try_to_number, try_cast to avoid it but getting error like "Function TRY_CAST cannot be used with arguments of types NUMBER(38,5) and NUMBER(38,0)". Can anyone please help me on resolving it or please suggest me that do i need to contact source team?

Upvotes: 0

Views: 593

Answers (1)

Sergiu
Sergiu

Reputation: 4578

That is because you have a timestamp into a numeric column. This is easily reproducible like in below screenshot:

enter image description here

You will need to change the field type if you want to accommodate timestamp values.

Upvotes: 1

Related Questions